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: Benchmarking and Baselining

Course Summary

When you experience a performance problem, how can you easily tell where the problem is without being able to compare against a known-good set of measurements? This course explains how to create a performance baseline for a SQL Server instance using bench


  • +

    Course Syllabus

    ● Introduction
        ◦ Course Introduction
        ◦ What is a Baseline?
        ◦ What is a Benchmark?
        ◦ Why Are They Important?
        ◦ Who Needs to Capture This Information?
        ◦ Course Structure
    ● What, When, and Where
        ◦ Introduction
        ◦ Deciding What Data to Capture
        ◦ Deciding What Data to Capture (2)
        ◦ Deciding What Data to Capture (3)
        ◦ Deciding When to Capture Data
        ◦ Deciding How to Store and Retrieve Data
        ◦ Summary
    ● Performance Monitor
        ◦ Introduction
        ◦ Perfmance Monitor Pros, Cons, and Overhead
        ◦ Use Performance Monitor When...
        ◦ Using Performance Monitor in Real-Time
        ◦ Demo: Performance Monitor
        ◦ Counters to Capture
        ◦ OS/Resource Counters to Capture
        ◦ OS/Resource Counters to Capture (2)
        ◦ OS/Resource Counters to Capture (3)
        ◦ SQL Server Counters to Capture
        ◦ SQL Server Counters to Capture (2)
        ◦ SQL Server Counters to Capture (3)
        ◦ SQL Server Counters to Capture (4)
        ◦ Counter Collection
        ◦ Data Collector Sets
        ◦ Demo: Data Collector Sets
        ◦ Processing Performance Monitor Data
        ◦ Demo: relog
        ◦ Processing Performance Monitor Data (2)
        ◦ Demo: PAL
        ◦ Summary
    ● Capturing Queries
        ◦ Introduction
        ◦ SQL Trace
        ◦ Demo: SQL Trace
        ◦ Extended Events
        ◦ Demo: Extended Events
        ◦ When to Use SQL Trace vs. Extended Events
        ◦ Clear Trace
        ◦ Demo: Clear Trace
        ◦ ReadTrace
        ◦ Demo: ReadTrace
        ◦ Benefits of Clear Trace vs. ReadTrace
        ◦ Replaying Workloads
        ◦ Summary
    ● Using DMVs
        ◦ Introduction
        ◦ When to Use DMVs
        ◦ Capturing DMV Data
        ◦ DMVs to Consider for Data Capture
        ◦ Demo: sys.dm_os_performance_counters
        ◦ DMVs to Consider for Data Capture (2)
        ◦ Demo: sys.dm_io_virtual_file_stats
        ◦ DMVs to Consider for Data Capture (3)
        ◦ Other Data You Can Capture
        ◦ Demo: sys.configurations
        ◦ WhoIsActive
        ◦ Demo: WhoIsActive
        ◦ Summary
    ● Pulling It All Together
        ◦ Introduction
        ◦ Before You Start
        ◦ Before You Start (2)
        ◦ Data Options
        ◦ Next Steps
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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