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

Mastering SQL Server Profiler - Video Training Course

By Brad McGehee,

Course Description

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.

Course Material

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

Course Modules

Introduction

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

Module1

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

Module2

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

Module3

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

Module4

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

Module5

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

Module6

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

 

Total article views: 5350 | Views in the last 30 days: 31
 
Related Articles
ARTICLE

Mastering SQL Server Profiler - Part 2: Profiler Architecture

This module, part 2 of the online training course "Becoming a Profiler Master", discusses the inner ...

ARTICLE

Mastering SQL Server Profiler - Part 5: Data Columns

The fifth module of the training course "Becoming a Profiler Master", looks in details at the data c...

ARTICLE

Mastering SQL Server Profiler - Part 4: Profiler Events

The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the ...

ARTICLE

Mastering SQL Server Profiler - Introduction

This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master...

ARTICLE

Mastering SQL Server Profiler - Part 6: Creating Custom Traces

The sixth and last module of the training course "Becoming a Profiler Master", describes how to crea...

Tags
profiler    
video    
 
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