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: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
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-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 5:18 PM
Points: 42,437, Visits: 35,492
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: Tuesday, July 8, 2014 11:20 AM
Points: 67, Visits: 242
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: Monday, July 21, 2014 9:19 AM
Points: 2,826, Visits: 8,462
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