07 October 2009

Mastering SQL Server Profiler – eBook Download

Download Brad McGehee's "from the ground up" guide to SQL Server's most powerful performance diagnostic tool.


“By mastering Profiler, the exceptional DBA can track down and fix SQL Server performance and other problems quickly and efficiently, and even spot potential problems before they cause real difficulties.”

Brad McGehee, author and experienced DBA.

Mastering SQL Server Profiler (link to eBook download – 16MB)


Table of Contents

  • 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

Why read this book?

SQL Server Profiler records data about various SQL Server events. This data is stored in a trace file and can be used to troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more.

For such a potentially powerful tool, Profiler is surprisingly underused. This must be due, at least in part, to the fact that it is occasionally a frustrating tool. The user interface is poor, it lacks many important features, it is poorly documented and, unless you have a lot of experience as a DBA, it is often hard to analyze the data you capture. As such, many DBAs tend to ignore it and this is distressing, because Profiler has so much potential to make a DBA’s life more productive.

This book will make it easier for you to learn how to use Profiler, analyze the data it provides, and to take full advantage of its potential for troubleshooting SQL Server problems.

Book Details

  • Paperback: 300 pages
  • Publisher: Red Gate Books

For more articles like this, sign up to the fortnightly Simple-Talk newsletter.

Tags: , , ,


  • Rate
    [Total: 14    Average: 4.1/5]

Brad M. McGehee is a MCITP, MCSE+I, MCSD, and MCT (former), and, until recently, the Director of DBA Education for Red Gate Software. He is now the editor of the SQL Server Central Stairway series. Brad is also an accomplished Microsoft SQL Server MVP, with over 16 years SQL Server experience and over 7 years training experience. Brad is a frequent speaker at User Groups and industry events (including SQL PASS, SQL Server Connections, devLINK, SQLBits, SQL Saturdays, TechFests and Code Camps), where he shares his 16 years of cumulative knowledge and experience. A well-respected name in SQL Server literature, Brad is the author or co-author of more than 15 technical books (freely available on SQLServerCentral) and over 275 published articles.

View all articles by Brad McGehee

  • Banutharan

    Its great ..Excellent eBook
    Hi Bred,

    Today I have downloaded eBook from simple-talk. I’m speechless very good stuff, you explained in very good manner along with example (Screenshot is added advantage).

    I appreciated your service and help.


  • Dugi

    Very nice profiler e-book
    Thanks for sharing! It seems very valuable ebook. Very nice collection of all relevant information about mastering with Profiler.

  • amitkumar31


  • rohanpahwa

    I think It is the best book for profiler
    I wanna become a DBA This book is useful for me
    But I want to contact with u Perhape I get some more useful book Can I ?.

  • pengleng

    Thank you very much professor for give me this ebooks

  • acuenca

    Thanks, I’ll read it certainly!

  • raman.jayaprakash

    Thanks Brad
    This is an excellent book for Sql Profiler. Please keep up the good work.

  • emsed1

    Thanks so much! Great book!

  • visao1234

    Thanks 🙂

  • Aiwinia Temba

    Thanks so much! Great book!

  • dinesh1310

    thank you