Using SQL Server Profiler

As you have seen, you can use SQL Server Management Studio to analyse and fine tune T-SQL statements. However, it will not help you to find which queries are potentially inefficient in your database solution. If you are interested in identifying the different types of queries and T-SQL statements that are being executed by various client applications inside your particular environment, you will have to use a tool such as SQL Server Profiler.

SQL Server Profiler is a very powerful utility that basically tries to capture the network activity between client applications and your SQL Server instance by listening in on the Tabular Data Stream (TDS). SQL Server Profiler can display this captured trace information in a very rich ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.