Previous Topic: SQL ServerNext Topic: Database Administration for Specific Platforms

Monitoring and Tuning for Specific Platforms › SQL Server › Procedure Cache

Procedure Cache

The procedure cache variable defines the percentage of memory allocated to the procedure cache after the server's memory needs are satisfied. The SQL Server Installation Default for Procedure Cache (30) is valid with optional tuning as needed.