SQL Overview VI - Monitoring Process Locks

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by David Bird » SQL Overview VI - Monitoring Process Locks

SQL Overview VI - Monitoring Process Locks

Rate Topic

Display Mode

Topic Options

Author

Message

David Bird

Posted Tuesday, March 30, 2010 10:43 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:29 PM
Points: 182, Visits: 952

Comments posted to this topic are about the item SQL Overview VI - Monitoring Process Locks

David Bird

My PC Quick Reference Guide

Post #893475

b_seattle

Posted Tuesday, March 30, 2010 11:25 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 8:25 PM
Points: 1, Visits: 143

Great article!

Just one thing to add-- there is a FREE tool out there that does this and more:

SQL Deadlock Detector

We used to have a job/package set up before we found SQL Deadlock Detector. What's nice about Deadlock Detector is that it can send emails when long running locks or deadlocks are detected. Can't beat that.

Post #893486

Luke C

Posted Wednesday, March 31, 2010 6:54 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:14 AM
Points: 238, Visits: 900

David, I just want to say thanks for creating this package. I have found it to be paramount in my ability to manage multiple instances and saves several hours every day by no longer having the need to visit each and every instance as part of my morning routine.

Luke C
MCP, MCTS, MCITP - Database Administrator & Database Developer

Post #893724

SQLRNNR

Posted Wednesday, March 31, 2010 1:27 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:46 PM
Points: 18,732, Visits: 12,329

Thanks for yet another nice article in this series.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

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 #894153

Jeff Olson-435047

Posted Thursday, April 01, 2010 11:35 AM

Forum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 8:24 AM
Points: 4, Visits: 140

This is great!

Post #895135

David Bird

Posted Thursday, April 01, 2010 11:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:29 PM
Points: 182, Visits: 952

Some components such as fn_ServerInstanceName is included in the file attachment for the previous article: SQL Overview Part V

David Bird

My PC Quick Reference Guide

Post #895150

David Bird

Posted Wednesday, October 20, 2010 7:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:29 PM
Points: 182, Visits: 952

I recently discovered the space in the new table SQL_Sysprocesses was not being freed even though the delete old rows statement was successful for each package execution. To fix this issue, I altered the table's index to be clustered. The database went from from 40 GB to 220 mb, a very big difference in space. I would recommend everyone making this change.

Afterwards I found the Microsoft KB article 913399 which confirmed this issue in SQL Server 2005, 2000, and 7. It provides several work arounds including the cluster index.

Sorry for the mistake

David Bird

My PC Quick Reference Guide

Post #1007707

cengland0

Posted Friday, July 22, 2011 6:03 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299

Can't wait to try this out. It's something I've always wanted to do but didn't have the time to develop it myself.

Post #1146568

jswong05

Posted Saturday, July 23, 2011 8:35 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 27, Visits: 421

You should always have a cluster index on a table when you can. You should always use row-versioning based isolation level - in SQL Server snapshot isolation. In Oracle, it is done at "Read Committed" isolation.

Jason
http://dbace.us
Tongue

Post #1147079

shurdul

Posted Saturday, March 02, 2013 6:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 10:37 AM
Points: 1, Visits: 1

Dosh Express is a Payday lender, and money can be transferred from our bank account to yours within minutes Payday Express
business lawyers melbourne

Post #1425850

« Prev Topic | Next Topic »

Permissions