tempdb space resource governance in SQL Server 2025 caps how much tempdb one Resource Governor group can fill. This post builds a capped group on a test server, fills tempdb with a temp table and a sort spill, shows error 1138 and the group counters, and cleans everything up.
SQL SERVER – Query Specific Wait Statistics and Performance Tuning
Query Specific Wait Statistics helped explain a sudden customer-query slowdown. The remaining workload ran normally, and recompilation had not helped.
Disable Resource Governor: Why RECONFIGURE Turns It On
To disable Resource Governor, run ALTER RESOURCE GOVERNOR DISABLE. The post shows why RECONFIGURE enables the feature, with a tested script that restores the state it finds. It also explains how saved pool limits come back to life.
How to Track Data Platform Service Level and Performance Before and After Consolidation?
Planning data platform consolidation? Track service level and performance before and after consolidation, so you know how well the planning worked.
Msg 41379: Restore Fails on Insufficient Memory in the Default Resource Pool
Msg 41379 stopped a restore because the default resource pool had insufficient memory for a database with In-Memory OLTP tables. We raised the memory available to the default pool to 90 percent, and the error disappeared.
SQL SERVER – Error – Disallowing page allocations for database ‘DB’ due to insufficient memory in the resource pool
My SQL Server 2016 error log kept saying ‘Disallowing page allocations for database due to insufficient memory in the resource pool’. What it means and the fix.
SQL SERVER – Resource Governor and Database Mapping
At SQLPass, an attendee asked how InMemory databases use memory. I show how Resource Governor and database mapping let you bind a database to a resource pool.