Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2000 - Blocking Happening again and again Expand / Collapse
Author
Message
Posted Friday, March 7, 2014 8:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 2:36 PM
Points: 321, Visits: 1,278
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


Aim to inspire rather than to teach.
SQL Server DBA
Post #1548770
Posted Friday, March 7, 2014 9:38 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:26 PM
Points: 21,351, Visits: 15,031
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1548790
Posted Tuesday, April 1, 2014 3:17 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 21, 2014 1:22 PM
Points: 20, Visits: 96
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?
Post #1557232
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse