March 7, 2014 at 8:50 am
Hi guys..
on sql 2000 ..from today morning blocking keep happening again and again even though killed SPID .. Reastarted SQL and app server. any one has idea what will be good action item?
also like to know scripts for sql 2000 gives detailed information about which query is blocking .
In sp_who2 shows IIS program name as blocking
thanks
March 7, 2014 at 9:38 am
use dbcc inputbuffer(spid) using the spid of the session that is causing the blocking. That will help you find what query is being run that is causing the blocking. Once that is determined, then it is a matter of tuning or fixing that query.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2014 at 3:17 pm
hate to ask this, but just wanted to clarify-
After the blocking started, you restarted the sql server and the application server, and once the application was in use again, the blocking started again?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply