Max/Min memory are both set to 10GB. I tried many variations on the memory settings, but the problem either stayed the same or got worse. Since I am not attached...

We have cognos on another server, and everytime a cube builds, which is throughout the day, we experience this problem. Cognos has to read the contents of the entire fact...

Yes, it is 64 bit and has 12.5gb total, 10 for SQL and 2.5 for the OS. the build is 9.00.3054.00(X64), which is SP2 with a patch a believe, and...

Interesting. We have been having this problem for a long time now, so I would say anything is worth a shot. Although this recommendation might be a hard sell to...

Sounds good. I won't actually be able to implement until tomorrow morning because I have processes that will not finish executing until later tonight. I appreciate your help. I have...

The request_Session_ID's are

54

69

83

80 --this is one of the culprits

87 --this is the other culprit

of these spid 80 and 87 actually have master (dbid=1) context in sysprocesses. They are both SQLAgent...

The other problem I see with this is that there really isn't a way to map the data from sys.dm_tran_locks back to a particular database that I am aware of....

The data it returns is

7000000000-0000-0000-0000-000000000000

8900000000-0000-0000-0000-000000000000

6900000000-0000-0000-0000-000000000000

8300000000-0000-0000-0000-000000000000

8000000000-0000-0000-0000-000000000000

for a top 5 with an actual total of 43 records just like this (000...Request_owner_guid)

When killing processes by the guid don't I have to do that...

Actually yes, there are several records returned for

SELECT request_session_id, request_owner_guid

FROM

sys.dm_tran_locks

I am not sure what these map to with regards to processes or activity on the server. (not too familliar...

Yeah, it's one of those problems that there just doesn't seem to be anywhere to go with.

If I stopped the SQL Server Service I still don't think I would...

Yeah, alter database is better than sp_dboption. It allows for more flexibility. In addition the sp_dboption is only available for backward compatibility from what I understand. I will get into...