Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

SQL Server Memory DeepDive – SQL Server Memory

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”

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