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

SQL Profiler and SQL Trace: These two features are the graphic and textual interface to trace SQL Server performance data by capturing and saving details about a given set of trig­gering “events.” ...

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.