Introduction to SQL Profiler
Things to Explore
Of course, there's more to SQL Profiler than I can cover in a single short article. Here are some other features that you might like to dig into as you get more familiar with its capabilities:
- You can save traces to a file or a SQL Server table. Saved traces can be used by the SQL Server Index Tuning Wizard to help tune your database.
- You can save traces to a SQL Script. This gives you a way to "replay" a set of actions in the future, without going back through the original source of the actions. This is useful for automated testing.
- You can replay traces directly in SQL Profiler.
- You can sort and filter the information captured to find performance bottlenecks or deadlocks in your application
All in all, SQL Profiler is a great tool for peering under the hood of your SQL Server installation. Learn how to use it and you're sure to save debugging time in the future.
Page 3 of 3