SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...

The two that really stand out for me here are SQL Agent, so fundamental for scheduling anything with SQL server, and Profiler, which, particularly for an in-house developed application, is like trying ...

Identify Blocked SQL Processes Quickly: Listing 1: SQL SERVER: Create the Database Block-Tracing Utility The database utility dba_BlockTracer extracts data about the running processes by inspecting ...