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: Common Performance Issue Patterns

Course Summary

There are a wealth of problems that can affect the performance of SQL Server workloads, and this course shows you more than 35 common performance issue patterns. With 17 detailed demos, you're shown how to recognize each pattern along with practical troub


  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Course Structure
    ● High-Level Issue Patterns
        ◦ Module Introduction
        ◦ Vendor Bias (1)
        ◦ Vendor Bias (2)
        ◦ Expertise Traps
        ◦ Missing Data
        ◦ Incomplete Data
        ◦ Lack of Troubleshooting Methodology
        ◦ Troubleshooting Downstream Issues
        ◦ Ignoring Capacity Considerations (1-2)
        ◦ Ignoring Capacity Considerations (3)
        ◦ Failure to Enforce Standards
        ◦ Missing Change Control
    ● I/O Patterns
        ◦ Module Introduction
        ◦ Inadequate I/O Paths (1)
        ◦ Inadequate I/O Paths (2)
        ◦ Demo: Inadequate I/O Paths
        ◦ I/O-Intensive Execution Plans (1)
        ◦ I/O-Intensive Execution Plans (2)
        ◦ Demo: I/O-Intensive Execution Plans
        ◦ Aggressive Checkpoint Activity
        ◦ Collocation with Bad Neighbors
    ● Concurrency Patterns
        ◦ Module Introduction
        ◦ Long-Term Blocking
        ◦ Demo: Long-Term Blocking
        ◦ Lock Escalation
        ◦ Accessing Objects Inconsistently
        ◦ Demo: Accessing Objects Inconsistently
        ◦ Forgotten Side-effects
        ◦ Demo: Forgotten Side-effects
        ◦ Hint Misuses and Restrictive Isolation Levels
    ● Memory Patterns
        ◦ Module Introduction
        ◦ Memory Pressure (1)
        ◦ Memory Pressure (2)
        ◦ Memory Pressure (3)
        ◦ Demo: Memory Pressure
        ◦ Query Execution Memory Issues (1)
        ◦ Query Execution Memory Issues (2)
        ◦ Demo: Query Execution Memory Issues
    ● Tempdb Patterns
        ◦ Module Introduction
        ◦ Allocation Page Contention (1)
        ◦ Allocation Page Contention (2)
        ◦ Demo: Allocation Page Contention
        ◦ Row Versioning Overhead
        ◦ Demo: Row Versioning Overhead
        ◦ Collocation with High I/O Databases
        ◦ Query Workspace Overhead
    ● CPU Patterns
        ◦ Module Introduction
        ◦ External CPU Pressure
        ◦ High Privileged Time
        ◦ User-Time SQL Server CPU Time (1)
        ◦ User-Time SQL Server CPU Time (2)
        ◦ Demo: User-Time SQL Server CPU Time
        ◦ I/O Correlated High CPU
        ◦ Demo: I/O Correlated High CPU
        ◦ Excessive Compilation and Recompilation (1)
        ◦ Excessive Compilation and Recompilation (2)
        ◦ Demo: Excessive Compilation and Recompilation
        ◦ Observer Overhead
        ◦ Demo: Observer Overhead
        ◦ Uninvited Parallelism
        ◦ Demo: Uninvited Parallelism
    ● Application Design Patterns
        ◦ Module Introduction
        ◦ Slow Fetches
        ◦ Demo: Slow Fetches
        ◦ Needless Queries
        ◦ Over and Under-Architecture (1)
        ◦ Over and Under-Architecture (2)
        ◦ Boil-the-Ocean Modules (1)
        ◦ Boil-the-Ocean Modules (2)
    ● Plan Quality Patterns
        ◦ Module Introduction
        ◦ Cardinality Estimate Issues
        ◦ Demo: Cardinality Estimate Issues
        ◦ Opaque Operations and Hidden Costs
        ◦ Demo: Opaque Operations and Hidden Costs
        ◦ Course Summary

     


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