This is a very good DMV script that gives you blocking/locking even on page level and the SQL statement each spid is running at the time. SELECT tl.request_session_id AS WaitingSessionID ‚wt.blocking_session_id AS BlockingSessionID ‚wt.resource_description ‚wt.wait_type ‚wt.wait_duration_ms ‚DB_NAME(tl.resource_database_id) AS DatabaseName ‚tl.resource_associated_entity_id AS WaitingAssociatedEntity ‚tl.resource_type AS WaitingResourceType ‚tl.request_type AS WaitingRequestType ‚wrt.[text] AS WaitingTSql ‚btl.request_type BlockingRequestType ‚brt.[text] AS […]
-
Knowledge Base
- Database Technology (13)
- Microsoft SQL Server (12)
- Sybase IQ (1)
- Knowledge Base (1)
- Database Technology (13)
-
Tags