SQL Server Memory Grants Deep Dive - Analytics, Warehouse, Reporting workloads
Details
This presentation will cover SQL Server ideal memory grant estimation, requested memory grant negotiation, interaction of memory grants with Resource Governor, use of MAX_GRANT_PERCENT and MIN_GRANT_PERCENT hints, additional memory grants during query/statement execution, and special considerations for queries with column store indexes.
Related topics
Business Intelligence
Data Management
Database Development
Database Professionals
SQL Server