Converting Trace to Extended Events

A walkthrough of a conversion of a SQL Trace setup to an Extended Event session.

Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events

Over the course of this stairway series, we're going to explore in detail the use of Extended Events as a diagnostic data collection tool, to track down causes of poor performance in SQL Server. This first level will start from a point known and familiar to many DBAs, namely the use of SQL Trace to track down and investigate long-running queries.

READ Data from default Trace

READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.

Deprecation

Trace Analysis script

Script to help you analyze a trace to find worst performing procs.

Automating SQL Traces

Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.

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

Compares and contrasts tracing using Profiler with server-side tracing, illustrating important performance differences so that one can choose the right tool for the task at hand.

Stairway to Server-side Tracing - Level 9: How to Automate SQL Traces using the Data Collector

In this level you will see how to employ the Data Collector feature of SQL Server to automate management of SQL Traces among multiple servers.

Stairway to Server-side Tracing - Level 8: How to Automate Traces with SSIS

Level 8 of this stairway series looks at the automation of your tracing using Integration Services.

Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass

A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.