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 Overview VI - Monitoring Process Locks Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 10:43 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:24 AM
Points: 182, Visits: 996
Comments posted to this topic are about the item SQL Overview VI - Monitoring Process Locks

David Bird

My PC Quick Reference Guide
Post #893475
Posted Tuesday, March 30, 2010 11:25 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 3:09 PM
Points: 1, Visits: 169
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
Posted Wednesday, March 31, 2010 6:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 21, 2014 6:43 AM
Points: 239, Visits: 999
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
MCSE: Data Platform, MCP, MCTS, MCITP - Database Administrator & Database Developer
Post #893724
Posted Wednesday, March 31, 2010 1:27 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 5:28 PM
Points: 20,483, Visits: 14,136
Thanks for yet another nice article in this series.



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 #894153
Posted Thursday, April 01, 2010 11:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 7:32 AM
Points: 4, Visits: 145
This is great!
Post #895135
Posted Thursday, April 01, 2010 11:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:24 AM
Points: 182, Visits: 996
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
Posted Wednesday, October 20, 2010 7:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 26, 2014 7:24 AM
Points: 182, Visits: 996
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
Posted Friday, July 22, 2011 6:03 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen 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
Posted Saturday, July 23, 2011 8:35 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:54 PM
Points: 27, Visits: 457
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
Post #1147079
Posted Saturday, March 02, 2013 6:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse