Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Locking Rss

Search for any content tagged locking

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   
 

Capture and Alert for Blocked SPIDS with SP_WHO2

This will capture locked/blocked spids and alert with the inputbuffer info as well as the login info. Then email it and record the history of the blocks.  Read more...
By Joshua A. Walker 2013/12/04 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 3,317 reads

Collect SQL Server/Process Information - Quickly

Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.  Read more...
By Rudy Panigas 2011/04/21 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 5,245 reads

View connection and Locking Information

This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address   Read more...
By sql frenzy 2010/05/17 | Source: SQLServerCentral.com | Category: sp_who2
Rating: |  Discuss |   Briefcase | 2,341 reads

Retrieve locking block-chain

This script utilize the DMV to quickly build the locking block-chain.  Read more...
By John Liu 2008/09/02 | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 2,490 reads

Switching tables

Switching tables describe the scenario of 2 tables containning data; while making a process on one tables the other table can continue and function in front of some application.  Read more...
By tomer lev 2008/09/05 | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 886 reads
   Items 1 to 5 of 5