Resource Governor
E56727
Resource Governor is a SQL Server feature that enables administrators to manage and control SQL Server workload and system resource consumption by defining and enforcing resource limits for different workloads.
Aliases (1)
Statements (53)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
→
workload management feature → |
| benefit |
enables multi-tenant resource isolation on a single instance
→
improves predictability of performance → prevents runaway queries from monopolizing resources → |
| classificationBasis |
application name
→
database name → host name → login name → time of day → |
| configurationScope |
server-level
→
|
| configuredWith |
SQL Server Management Studio
→
Transact-SQL (T-SQL) → |
| controlsResource |
CPU
→
I/O (indirectly via workload control) → memory → |
| developedBy |
Microsoft
→
|
| hasComponent |
default resource pool
→
default workload group → internal resource pool → user-defined resource pool → user-defined workload group → |
| hasDocumentation |
Microsoft Docs for SQL Server Resource Governor
→
|
| introducedInVersion |
SQL Server 2008
→
|
| monitoredBy |
Dynamic Management Views (DMVs)
→
|
| partOf |
Microsoft SQL Server
→
|
| primaryPurpose |
control system resource consumption
→
manage SQL Server workload → |
| requires |
classifier function for custom routing of sessions
→
|
| runsOn |
SQL Server Database Engine
→
|
| supports |
CPU caps for workloads
→
defining resource limits per workload → governance of ETL workloads → governance of ad-hoc queries → governance of batch workloads → governance of reporting workloads → maximum resource limits → memory caps for workloads → minimum resource guarantees → prioritizing critical workloads → reconfiguration without server restart → workload isolation → |
| supportsVersion |
SQL Server 2008
→
SQL Server 2008 R2 → SQL Server 2012 → SQL Server 2014 → SQL Server 2016 → SQL Server 2017 → SQL Server 2019 → SQL Server 2022 → |
| usesConcept |
classifier function
→
resource pool → workload group → |
Referenced by (2)
| Subject (surface form when different) | Predicate |
|---|---|
|
Resource Governor
("Microsoft Docs for SQL Server Resource Governor")
→
|
hasDocumentation |
|
SQL Server
→
|
supportsFeature |