Mastering SQL Server Profiler

Av rating:

Total votes: 5
Total comments: 1

send to a friend

printer friendly version

Mastering SQL Server Profiler

30 January 2009

by Brad McGehee

"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.

Download the eBook (To download the eBook you need to be a member of Simple Talk, the download link will take you to the registration page.)

Buy the printed book

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

This article has been viewed 4669 times.

Subject:	Sample Code for Mastering SQL Server Profiler‏
Posted by:	Toqeer (view profile)
Posted on:	Wednesday, July 20, 2011 at 11:41 PM
Message:	Assalam-O-Alaikum (May peace be upon you) First of all i must say thanks for writing such a nice book. Few days back Profiler was a mystery to me. Now, i am reading it and getting grip on it day by day. Untill chapter 3 there is no need of sample code/SQL statements used in the book. From chapter 4 "How to Identify Slow Running Queries" and onwards i think, will be good if you can provide me with sample code of examples used in the book. I am doing practical on my own machine for getting as much understanding as possible. Waiting for your reply, Thanks and God Bless You.

Table of Contents

Why read this book?

Book Details