Introduction to SQL Profiler, Page 3
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.
Mike Gunderloy is the author of over 20 books and numerous articles on development topics, and the lead developer for Larkware. Check out his latest book, Coder to Developer from Sybex. When he's not writing code, Mike putters in the garden on his farm in eastern Washington state.