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 ...

Here’s a bit of trivia—due to its Sybase heritage, SQL Server was the only Microsoft product to offer the CPU affinity and affinity masking configuration setting for decades. In those early days of ...

Second, SQL Server 2000’s Profiler introduces template files, which replace both the Create Trace Wizard and the storage of trace definitions in the Registry.

SQL Server has long offered a two-part toolkit for basic instrumentation of its engines, both relational and analytical: SQL Profiler and Windows Performance Monitor (PerfMon), also known as Windows ...

The SQL Profiler has a neat Deadlock Graph feature which is very useful. Let’s take a look…. When SQL Server detects a deadlock, it has to do something about it.