Thank this author by sharing:
By Brad McGehee, 2013/06/19
An exceptional DBA will be able to quickly and efficiently track down the cause of SQL Server under-performance. In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering everything you need to know to start using SQL Server Profiler, a powerful performance monitoring and analysis tool.
This video training course is based on the book Mastering SQL Server Profiler, also by Brad McGehee. It contains detailed descriptions of many of the concepts covered in this course and provides ideal support material. You can download a free copy of the e-Book from the Red Gate website:
Download the SQL Server Profiler eBook
Title: Introduction to the Profiler Video Course
Description: The Introduction describes some motivating factors for taking the time to master the Profiler tool. It then provides a brief overview of the topics covered, how the course is structured, and advice on how to get the most out of it.
Module length: 7 minutes
Title: Introduction to Profiler Concepts
Description: Defines the key terms and concepts that you'll encounter that underpin Profiler, and that you'll encounter throughout this course.
Module length: 8 minutes
Title: Profiler Architecture
Description: Discusses the inner workings of Profiler and examines the workflow of producing, capturing and consuming SQL Server events.
Module length: 5 minutes
Title: Getting Started with SQL Server Profiler
Description: Start working with Profiler in earnest. Learn how to start, stop and control Profiler and how to save the traces.
Module length: 11 minutes
Title: Mastering SQL Server Profiler Events
Description: Examines the many events and event categories that can be collected with Profiler, and how and when they can be used
Module length: 12 minutes
Title: Mastering SQL Server Profiler Data Columns
Description: Examines the important data columns that are associated with the Profiler events discussed in module 4.
Module length: 10 minutes
Title: How to Create a Custom Profiler Trace
Description: A step-by-step guide to creating custom Profiler traces, tailored to the specific performance problem you wish to investigate.
Module length: 16 minutes
This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner ...
The fifth module of the training course "Becoming a Profiler Master", looks in details at the data c...
The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the ...
This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master...
The sixth and last module of the training course "Becoming a Profiler Master", describes how to crea...
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
