- Sybase® SQL Server Performance and Tuning Guide
Chapter 15
Memory Use and Performance
- How Memory Affects Performance
- Memory Fundamentals
- How Much Memory to Configure
- Caches on SQL Server
- The Procedure Cache
- The Data Cache
- Named Data Caches
- Sizing Named Caches
- Overhead of Pool Configuration and Binding Objects
- Maintaining Data Cache Performance for Large I/O
- Speed of Recovery
- Auditing and Performance