Monitoring and Tuning SQL Server with Profiler

March 3, 2006

SQL Server comes with several excellent tools for monitoring and tuning application performance. Profiler is perhaps the most powerful of these tools; it allows you to spy on and analyze the impact of SQL statements sent to your server.

This article provides a very brief overview of main Profiler features. I also discuss some of the advanced Profiler features: profiler templates, replaying a previously recorded trace, and recording traces without Profiler’s graphical user interface.

The article continues at http://www.informit.com/articles/article.asp?p=454000&rl=1