May 18, 2000
This session will talk about what the Profiler is, and then tell you when, why, and how you should use. We will go into the details of various Profiler components and discuss their applicability to specific troubleshooting scenarios (with examples). We will also discuss the underlying extended stored procedures and how to use them outside of the GUI. In addition, we will look into the way Profiler works with other tools such as the Index Tuning Wizard. Finally, we will discuss common issues surrounding Profiler, and provide some simple tricks and shortcuts.