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

I m facing lot of blocking and open train issue in my office. Expand / Collapse
Author
Message
Posted Saturday, August 17, 2013 9:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:50 AM
Points: 72, Visits: 259
I m facing lot of blocking and open train issue in my office.


please help me if i get this types of issue then how to troubleshooting blocking and open train issue. Please give me any script to find it also,

Please help me i m very new and i dont have much more experience.
Post #1485550
Posted Sunday, August 18, 2013 2:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:21 AM
Points: 39,877, Visits: 36,221
Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1485549-391-1.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1485566
Posted Sunday, August 18, 2013 2:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, September 18, 2014 1:50 AM
Points: 72, Visits: 259
I am sorry.. and thanks for reply
Post #1485568
Posted Sunday, August 18, 2013 7:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 1:06 PM
Points: 2,827, Visits: 8,479
You can find scripts that will show you the blocking processes. Then identify the primary blocking process. From that point you need to identify what the process is doing, what others are doing, and the cause of the blocking.

You may see recommendations to kill the lead process, but that is a bad idea without understanding what is going on. You need to identify the "what, where, why ..." and actually solve the problem.



Post #1485579
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse