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

Learn how to benchmark a SQL Server instance and create a performance baseline to compare against for simplified troubleshooting, applicable for developers, DBAs, and anyone who uses SQL Server from SQL Server 2005 onwards


  • +

    Course Syllabus

    Introduction
    - 14m 38s

    —Course Introduction 2m 29s
    —What is a Baseline? 2m 51s
    —What is a Benchmark? 2m 9s
    —Why Are They Important? 4m 0s
    —Who Needs to Capture This Information? 2m 4s
    —Course Structure 1m 5s
    What, When, and Where
    - 18m 13s

    —Introduction 3m 15s
    —Deciding What Data to Capture 1m 47s
    —Deciding What Data to Capture (2) 1m 49s
    —Deciding What Data to Capture (3) 1m 39s
    —Deciding When to Capture Data 3m 52s
    —Deciding How to Store and Retrieve Data 3m 14s
    —Summary 2m 37s
    Performance Monitor
    - 1h 6m
    Capturing Queries
    - 49m 27s
    Using DMVs
    - 42m 33s
    Pulling It All Together
    - 9m 20s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

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
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