This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.  Read more...

We've all had them. One of those stored procedures that is huge and contains complex business logic which may or may not be executed. These procedures make it an absolute nightmare when it comes to debugging problems because they're so complex and have so many logic offshoots that it's very easy to get lost when you're trying to determine the path that the procedure code took when it ran. Fortunately Profiler lets you define custom events that you can raise in your code and capture in a trace so you get a better window into the sub events occurring in your code.  Read more...

In Part 2 of our series we will examine how to create custom templates and how to save collected trace data.  Read more...

The Trace File Source adapter is a useful addition to your SSIS toolbox. It allows you to read 2005 and 2008 profiler traces stored as .trc files and read them into the Data Flow. From there you can perform filtering and analysis using the power of SSIS  Read more...

The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.  Read more...

The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.  Read more...

The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.  Read more...

This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.  Read more...

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

In this video written by MVP Brad McGehee you can learn how to get started using the Profiler GUI.  Read more...

This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.  Read more...

In this 6-module course, Brad McGehee provides an in-depth, step-by-step guide to mastering the basics of SQL Server Profiler, a powerful performance monitoring and analysis tool.  Read more...

Many SQL Server developers and DBAs have, in the past, had their own favourite diagnostic Stored Procedures for investigating blocking issues. But since SQL Server 2005, it's a good idea to use the SQL Profiler for all but the most complex problems. Brad McGehee takes us through the steps...  Read more...

SQL Server Profiler can troubleshoot a wide range of SQL Server issues, such as poorly-performing queries, locking and blocking, excessive table/index scanning, and a lot more. Brad's book will allow you to master the use of this versatile tool.  Read more...

This provides information about traces that are defined on SQL Server 2005.  Read more...

How to test and tune a stored procedure?  Read more...

Read more...

Read more...

Read more...

The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.  Read more...

In this video written by MVP Brad McGehee you can learn how to get started using the Profiler GUI.  Read more...

This is the introductory module for the SSC Online Video Training course, Becoming a Profiler Master. In it, MVP Brad McGeHee will discuss some of the critical factors that might persuade you of the need to master this powerful SQL Server profiling tool.  Read more...