DBCC INPUTBUFFER shows very little. In SQL Server 2016, the new sys.dm_exec_input_buffer function gives far more details about the last statement sent.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
DBCC SQLPERF can report log usage or reset cumulative wait and latch statistics. I separate reporting from resetting the baseline.
SQL SERVER – Running CHECKDB with Minimum Repair Level
CHECKDB found 39 consistency errors and said repair_allow_data_loss is the Minimum Repair Level, but the reader could not finish the repair. Here is my reply.
SQL SERVER – Ghost Cleanup Getting Hung and Blocking Checkpoint Process. What’s Wrong?
At a client, ghost cleanup was hung and blocking the checkpoint on a user database, with buffer latch timeouts in the ERRORLOG. Here is what I found.
SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT
A SharePoint check-in failed with Msg 8115, Arithmetic Overflow Error converting IDENTITY to data type INT. How I found the table with Profiler and fixed it.
Work Table Page Could Not Be Moved: DBCC SHRINKFILE on TempDB
A work table page can stop DBCC SHRINKFILE from reaching the size you asked for in tempdb. This post shows tested queries that compare configured and current file sizes, split tempdb space by object type and find the sessions that hold it. The original client case needed a planned restart to reset the file sizes.
DMV to Replace DBCC INPUTBUFFER Command – Interview Question of the Week #100
Is there a DMV to replace the DBCC INPUTBUFFER command? An interview question that caught me off guard, answered with sys.dm_exec_input_buffer.