October 25, 2005 at 9:22 am
We have some issues with our Sql server (for 30 minutes CPU usage ~100%) with 2 databases- DB1 and DB2. From CurrentActivity window I see a lot of applications connected to DB1, but in pretty long (60 items) blocking lock list (sp_blockinglocks) I have DB1 as DB name and PK_tbl2 as resource object name, where tbl2 belongs to DB2. How it can be? I checked dependencies, stored procedure, etc. Nothing exists that point from DB1 to tbl2 in DB2. I appreciate any tips. Thanks
October 25, 2005 at 10:29 am
sure sp_blockinglocks is written alright? (can't find it in the books online)
October 25, 2005 at 10:42 am
It's not from MS-taken from Kalen's InsideSQLServer website. Search Internet
October 25, 2005 at 5:39 pm
Check the sp_blocker_pss80 procedure from Microsoft PSS
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509
This will give you more idea on what is going on.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply