SQL Server Memory DeepDive – SQL Server Memory

DM-SQLDIOLTP-EN

In this one-day-course we take a look how SQL Server manages the memory and how it works with Execution and Cache Memory.

}

Duration: 8 hours

Level: 300

What does this course cover?

Proper memory management is an important component of a well-performing SQL Server. In this one-day-course we take a look how SQL Server manages the memory and how it works with Execution and Cache Memory. We see where problems might appear and develop, implement and monitor a best-practice.

 

Pre-requisites: What do you need to know?

Experience with SQL Server Administration.

“Herr Albert beherrscht sein Fachgebiet und kann sein Wissen sehr gut vermitteln”

WHEN and WHERE is this course running?

Course outline

Module 01
  • SQL Server Memory
    • Windows Memory Review
    • Architecture
    • Configuration
    • Best Practice
  • SQL Server Optimization and Execution Memory
    • Memory Grants
    • Sort und Hash Warnings
    • Resource Governor
  • Caches
    • SQL Buffer Pool
      • Monitoring and Configuration
    • SQL Server Plan Cache
      • Common Problems
      • Caching versus Recompile
      • Monitoring
      • Best practices
    • Other Caches

All our courses can be offered as a private delivery and tailored for your team's specific needs

WHEN and WHERE is this course running next?

This course may be scheduled in more than one region. Please check availability in your country.