SQL Server Performance

TSQL: How to find a frequently executed TSQL statements that causes blocking issues?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 2, 2010.

  1. Anonymous New Member

    If you know about SP_WHO2 (undocumented) (DBA savior) statement from SQL Server 7/2000 days you need no introduction to find what SPID is blocking and which is getting blocked. Here is another incident that caused much of chaos on a SQL instance that has been upgraded from SQL 7 to 2000 and then to 2008 directly! All is well until 2 weeks on newly married 2008 platform and trouble started when the batch process has been executed for first time on this new instance. This has escalated as a serious...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/08/02/9408.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9408" width="1" height="1">

Share This Page