Using SQL Server Profiler SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.

To audit SQL Server 7.0 activity on a deeper level, you could use the Profiler to capture both successful logins and SQL statements issued by users.

First, where Profiler under SQL Server 7.0 used the Registry to store connection information and sample trace definitions, SQL Profiler on Server 2000 does not.

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.

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

Using SQL Server Profiler SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.