MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Collecting and Analyzing Trace Data

Course Summary

One of the easiest ways to collect information about SQL Server workloads is to capture trace information. This course will introduce you to using SQL Trace and SQL Profiler for tracing SQL Server activity, including common pitfalls and problems to avoid.

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Collecting Trace Information
        ◦ Workload Analysis
        ◦ Course Structure
    ● SQL Trace Architecture
        ◦ Introduction
        ◦ What is SQL Trace?
        ◦ What are Events?
        ◦ The Trace Controller
        ◦ Event Producers
        ◦ Traces
        ◦ I/O Providers
        ◦ When to use SQL Trace
        ◦ Security Considerations
        ◦ Summary
    ● Using SQL Server Profiler
        ◦ Introduction
        ◦ What is Profiler?
        ◦ Creating New Traces
        ◦ Demo: Creating a New Trace from Scratch
        ◦ Demo: Creating a New Trace from a Template
        ◦ Demo: Creating a New Trace from a Trace File
        ◦ Filtering Trace Events
        ◦ Trace Templates - Introduction
        ◦ Trace Templates - SP_Counts and Standard
        ◦ Trace Templates - TSQL and TSQL_Duration
        ◦ Demo: TSQL_Duration Template
        ◦ Trace Templates - TSQL_Grouped and TSQL_Locks
        ◦ Trace Templates - TSQL_Replay and TSQL_SPs
        ◦ Trace Templates - Tuning
        ◦ Demo: Trace Templates
        ◦ Saving Captured Data
        ◦ Demo: Saving Captured Data
        ◦ Tips for Tracing with Profiler
        ◦ Summary
    ● Server-Side Trace
        ◦ Introduction
        ◦ Performance Comparison
        ◦ The SQL Trace DMVs
        ◦ Demo: Trace DMVs
        ◦ Programmatically Creating Traces
        ◦ sp_trace_create
        ◦ sp_trace_setevent
        ◦ sp_trace_setfilter
        ◦ sp_trace_setstatus
        ◦ Demo: Programatically Creating Traces
        ◦ Generating Trace Scripts with Profiler
        ◦ Demo: Scripting Trace from Profiler
        ◦ Summary
    ● Tracing Scenarios
        ◦ Introduction
        ◦ Default Trace in SQL Server
        ◦ Events Captured by the Default Trace
        ◦ Common Questions about the Default Trace
        ◦ Scenarios to use the Default Trace
        ◦ Demo: Default Trace
        ◦ Identifying Blocking Issues
        ◦ Demo: Identifying Blocking Issues
        ◦ Identifying Deadlock Issues
        ◦ Demo: Identifying Deadlock Issues
        ◦ Identifying Recompile Issues
        ◦ Demo: Identifying Recompile Issues
        ◦ Security and Compliance Auditing
        ◦ Demo: Security and Compliance Auditing
        ◦ Capturing a Tuning Workload
        ◦ Demo: Capturing a Tuning Workload
        ◦ Capturing a Replay Workload
        ◦ Demo: Capturing a Replay Workload
        ◦ Common Trace Mistakes
        ◦ Summary
    ● Analzying Trace Data
        ◦ Introduction
        ◦ Analyzing Trace Data with Transact-SQL
        ◦ Demo: Analyzing Trace Data with Transact-SQL
        ◦ Analyzing Data in Profiler
        ◦ Demo: Analyzing Data in Profiler
        ◦ Demo: Merging PerfMon Data in Profiler
        ◦ Extracting Trace Events
        ◦ Demo: Extracting Trace Events
        ◦ Normalizing Trace Data
        ◦ Demo: sp_get_query_template
        ◦ Demo: ReadTrace from RML Utilities
        ◦ Demo: ClearTrace
        ◦ Database Tuning Advisor Workload Analysis
        ◦ Demo: DTA Workload Analysis
        ◦ Summary
    ● Replaying Trace Workloads
        ◦ Introduction
        ◦ Profiler Replay
        ◦ Profiler Replay Requirements
        ◦ Demo: Profiler Replay

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top