SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

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

published 651 days, 13 hours, 55 minutes ago posted by

sa 660 days, 14 hours, 46 minutes ago

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

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...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: Blocking, DBA, deadlocks, DMV, locks, sp_who2, SQL Server, sys_dm, table, TSQL

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

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

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up