SQL Profiler is the graphical tool that lets you capture and analyzer SQL Server events in real time. I'm going to drill a bit deeper into this useful tool and show you an interesting book by Brad McGehee. You can download it from here.
- Chapter 01: Getting Started with Profiler
- Chapter 02: Working with Traces and Templates
- Chapter 03: Profiler GUI Tips and Tricks
- Chapter 04: How to Identify Slow Running Queries
- Chapter 05: How to Identify and Troubleshoot SQL Server Problems
- Chapter 06: Using Profiler to Audit Database Activity
- Chapter 07: Using Profiler with the Database Engine Tuning Advisor
- Chapter 08: Correlating Profiler with Performance Monitor
- Chapter 09: How to Capture Profiler Traces Programmatically
- Chapter 10: Profiler Best Practices
- Chapter 11: Profiler Events and Data Columns Explained
You should also check SQL Profiler Tips and Tricks and SQL Profiler Best Practices
Keyboard Shortcuts
- Ctrl+Shift+Delete to clear the current trace window
- Ctrl+F to open the Find dialog box
- F3 to find the next match
- Shift+F3 to find the previous match
- Ctrl+N to open a new trace
- F5 to start a replay
- Shift+F5 to stop a replay
- F9 to toggle a breakpoint
- F10 to single-step
- Ctrl+F10 to run to the cursor
No comments:
Post a Comment