After a lot of delays, my book on how to use SQL Server Profiler has been published by Simple-Talk Publishing, and it can be downloaded free here. A little later, this book will be available for purchase as a paperback book from Amazon.com.
The 283 page book is titled Mastering SQL Server Profiler, and as you can guess from the title, the focus is on learning how to use SQL Server Profiler. Not only does it cover the basics, it includes a discussion of every Profiler event and data column that can be collected, and in addition, shows you how to apply it to your day-to-day work as a DBA or developer.
The book covers these topics:
- Getting Started with Profiler
- Working with Traces and Templates
- Profiler GUI Tips and Tricks
- How to Identify Slow Running Queries
- How to Identify and Troubleshoot SQL Server Problems
- Using Profiler to Audit Database Activity
- Using Profiler with the Database Engine Tuning Advisor
- Correlating Profiler with Performance Monitor
- How to Capture Profiler Traces Programmatically
- Profiler Best Practices
- Profiler Events and Data Column Explained
At 283 pages, you might think that I have covered everything there is to know about Profiler, but that is not the case. There is a lot more that I could have covered, but I had a 300 page limit for the book and had leave a lot out. On the other hand, if you read and master all of the content in this book, you will be a long ways toward becoming a Profiler Master.
|Share this post :|