Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Mastering SQL Server Profiler

By Brad McGehee,

High Performance SQL Server Series

SQL Server ProfilerMastering SQL Server Profiler by Brad McGehee
(1st Edition, January 2009)

Download eBook (PDF): Free
Buy Printed Book: $29.99
Kindle Edition: Coming Soon


" I have been a SQL Server DBA for about 14 years, and I regard Profiler as one of the most useful of SQL Server's "built-in" tools" -- Brad McGehee

View Table of Contents
View Sample Chapter


View Related Books:


Editorial Review

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.

About the Author

Brad is an Industry speaker, writer, and consultant on Microsoft SQL Server, specializing in SQL Server performance tuning, clustering, and high availability. He is the founder of www.SQL-Server-Performance.Com, and oversaw its growth to 350,000 visits each month. He is now Director of DBA Education at Red Gate Software. Brad is a frequent speaker at SQL PASS, SQL Connections, SQL Server user groups, and other industry seminars, and he is the author or co-author of more than 12 technical books and over 100 published articles. He spends what time he has left with his family in Hawaii. He is a Microsoft SQL Server MVP, MCSE+I, MCSD, MCT.


Book Details

Paperback: 300 pages
Publisher: Red Gate Books
ISBN:

Total article views: 17225 | Views in the last 30 days: 95
 
Related Articles
FORUM

server performance.

profiler

FORUM

SQL Server Profiler

How to start Profiler automatically to monitor a remote Server

ARTICLE

Mastering SQL Server Profiler - Video Training Course

In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering the bas...

ARTICLE

Stairway to Server-side Tracing - Level 10: Profiler versus Server-Side tracing

Compares and contrasts tracing using Profiler with server-side tracing, illustrating important perfo...

FORUM

where will be the newly created sql server profiler will store

about the sql server profiler template

 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones