SQL Server Performance

TSQL to findout blocking and locks on a SQL Server?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Dec 7, 2007.

  1. Anonymous New Member

    Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly deletes). As you are aware the inserts operations will have to wait to update the table where the table is locked until the delete transaction is commited. Similarly you can run a TSQL to find out what kind of blocking and locking is occuring on the...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/07/2877.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2877" width="1" height="1">

Share This Page