SQL 2005, You can enable traceflags to allow MSSQL Server produce more verbose information to errorlog. Trace flag 1222 Trace flag 1204
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 […]
Sybase IQ is an analytics server designed specifically for analytics, data warehousing, and business intelligence environments. Distinguished from conventional databases by its column-oriented, grid-based architecture, patented data compression, and advanced query optimizer, Sybase IQ is deployed in a wide variety of settings delivering unmatched performance, flexibility, and economy in even the most challenging reporting and […]