Monitoring and Tuning SQL Server with Profiler
March 3, 2006[From Informit]
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 Profilers graphical user interface.
The article continues at http://www.informit.com/articles/article.asp?p=454000&rl=1