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

Keep up to date with Simple-Talk

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

This post has been viewed 4234 times – thanks for reading.

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

Brad McGehee

View all articles by Brad McGehee

Related articles

Also in Free Stuff

Under the Hood of .NET Memory Management

As well-engineered as the .NET framework is, it's not perfect, and it doesn't always get memory management right. To write truly fantastic software, you need to understand how .NET memory management actually works. This book will take you from the very basics of memory management, all the way to how the OS handles its resources, and will help you write the best code you can.… Read more

Also in Performance

T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem

Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code lavishly. Phil Factor's SQL Speed Phreak challenge produced some memorable code, but can SQL features introduced since then help to produce code that performs as well and is also easy to understand? Aunty Kathi investigates.… Read more

Also in SQL

Relational Algebra and its implications for NoSQL databases

With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists.… Read more

Also in SQL Server

SQL Server System Functions: The Basics

Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.… Read more
  • 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

Join Simple Talk

Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.

Sign up

See what's happening behind the scenes

Take a peek at the bowels of the ship – the lower decks – the actual servers of SQL Server Central itself.

See what's happening