July 21, 2008 at 7:09 pm
Hello SQL Master DBA
anyone can help me to find the script for this issue.
(There are lots of sleeping connections from the problematical host (hmcapp04-pdc.nhg.local/10.50.137.60). The oldest connection has been there for more than 17 minutes, and some of the connections had been idle for more than 10 minutes.) What does it means for this issue, anyone can give me a script for this issue, to find whos is in idle for long time and whos block by.
Thank you
Ayie
July 22, 2008 at 12:43 am
No need to ask this again. There are already a number of answers to your older post.
Duplicate thread. No replies to this please. Direct replies to the older thread at:
http://www.sqlservercentral.com/Forums/FindPost537514.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:49 am
Hi Gail Shaw
Do you have a script to capture the blocking spid, show all the detail in a one whole grid, thanks
July 22, 2008 at 12:54 am
What's wrong with the one Jack gave you in the other thead?
Please reply there. Multiple threads just waste people's time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply