-- sp_statement_completed, sql_batch_completed and unprepare_sql events to track usage of a nominated stored procedure. -- It then starts the EE session, collects data for 2 hours and shreds the XML ...

SQL DBA Interview Questions 38: A stored procedure was running in 10 seconds yesterday, but today it’s taking 10 minutes. As a DBA, what steps would you take to troubleshoot and optimize it ...

This SQL code runs the dba_BlockTracer stored procedure. The output shows two grids; the first shows that the root-blocking spid is 86, and the second shows two blocked spids, 122 and 104. Both spid ...