January 12, 2009 at 8:17 am
hi i am having a database which i am using from past 2 two and my application was also running verywell,nnow suddenly my application has become very slow and when i check locks in current activity it it shows spid 54(blocked by 59) or some a time some other id is blocked by some other can please some one help on this. i am not able to access my application.
January 12, 2009 at 8:29 am
If this is on SQL Server 2005, try using the blocked process report to identify the blocking statement and object and then look at the code/indexes/physical design and determine how to minimize the blocking/locking time of the execution:
http://www.sqlservercentral.com/articles/Blocking/64474/
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 12, 2009 at 8:37 am
thx but its sql 2000
January 12, 2009 at 10:13 am
Try using the sql_handle process, it will show the code running for each spid in query.
You can run for each spid in the blocking tree and you'll get all the code, so you can see what is causing the blocking.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply