O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required