Troubleshoot Database Concurrency in SQL Server with sp_locks

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 30 Nov 2010 07:00:00 UT Indexed on 2010/12/08 5:53 UTC
Read the original article Hit count: 218

Filed under:
sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue. SQL Backup Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.

© SQL Server Central or respective owner

facebook twitter digg google delicious technorati stumbleupon myspace wordpress linkedin gmail igoogle windows live tumblr viadeo yahoo buzz yahoo mail yahoo bookmarks favorites email print

Categories cloud

.NET ASP.NET iphone linux python Windows mysql android sql windows-7 html c ruby-on-rails css objective-c ubuntu networking sql-server wpf asp.net-mvc ruby database Xml apache AJAX osx security regex django Performance 12.04 windows-xp mac web-development iphone-sdk vb.net Silverlight apache2 flash server perl best-practices email installation eclipse visual-studio algorithm windows-server-2008 winforms wcf firefox bash dns /Oracle