Adam- thanks for the info. I'm not much of a developer so I may have to buy a tool.

I changed the where clause a bit but it still returns nothing and there are about 1000 valid rows in this table

USE [EventManagement]

GO

/****** Object: View [dbo].[vwR_KeyMembersFilter] ...

when I run the job in QA it runs successfully although its not adding the date to fields, when I query the table the fields are NULL. I tried to...

the disks busy all day. LanDesk is very read intensive (all day) and there are other dbs on the same box that also do a lot of reads.

SQL Buffer manager: Page life expectency = 4063 avg

Memory: Pages/sec = 0.081 avg

SQL Buffer manager: Buffer cache hit ratio = 99.62 avg

SQL Buffer manager: Page life expectency = 99.88 avg

ok, the counters were just in a different spot

SQL Buffer manager: Buffer cache hit ratio

SQL Buffer manager: Page life expectency

this is also sql 2000 standard edition so is AWE part...

oops this is a sql 2000 box

I started the trace but couldnt check the counters since its sql2k. What counters should I check for? and how do I check to...

Thanks, sp_helplogins is what I was looking for

Yes you are right, after digging in Technet I found exactly what I was looking for.

Thanks

http://technet.microsoft.com/en-us/library/ms159155.aspx