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.
All labels observed (2)
| Label | Occurrences |
|---|---|
| Microsoft Docs for SQL Server Resource Governor | 1 |
| Resource Governor canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T452342 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Resource Governor Context triple: [SQL Server, supportsFeature, Resource Governor]
-
A.
RDS
RDS is a Canadian French-language sports television network that broadcasts a wide range of professional and amateur sporting events.
-
B.
DSV Limiting Factor
DSV Limiting Factor is a deep-submergence vehicle designed for repeated crewed descents to the deepest parts of the ocean, including the Challenger Deep in the Mariana Trench.
-
C.
Database System Concepts
Database System Concepts is a widely used foundational textbook in computer science that introduces the principles, design, and implementation of modern database systems.
-
D.
Resource Management Offices
Resource Management Offices are specialized units within the U.S. Office of Management and Budget that oversee and coordinate budgetary, policy, and program management for specific federal departments and agencies.
-
E.
IEEE 802.1Qdm resource management standard
The IEEE 802.1Qdm resource management standard is an IEEE 802.1 Time-Sensitive Networking (TSN) specification that defines mechanisms for managing and allocating network resources to ensure predictable, reliable performance in bridged and time-sensitive Ethernet networks.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Resource Governor Target entity description: 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.
-
A.
RDS
RDS is a Canadian French-language sports television network that broadcasts a wide range of professional and amateur sporting events.
-
B.
DSV Limiting Factor
DSV Limiting Factor is a deep-submergence vehicle designed for repeated crewed descents to the deepest parts of the ocean, including the Challenger Deep in the Mariana Trench.
-
C.
Database System Concepts
Database System Concepts is a widely used foundational textbook in computer science that introduces the principles, design, and implementation of modern database systems.
-
D.
Resource Management Offices
Resource Management Offices are specialized units within the U.S. Office of Management and Budget that oversee and coordinate budgetary, policy, and program management for specific federal departments and agencies.
-
E.
IEEE 802.1Qdm resource management standard
The IEEE 802.1Qdm resource management standard is an IEEE 802.1 Time-Sensitive Networking (TSN) specification that defines mechanisms for managing and allocating network resources to ensure predictable, reliable performance in bridged and time-sensitive Ethernet networks.
- F. None of above. chosen
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
ⓘ
SQL ⓘ
surface form:
Transact-SQL (T-SQL)
|
| controlsResource |
Intel processors
ⓘ
surface form:
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 |
Resource Governor
self-linksurface differs
ⓘ
surface form:
Microsoft Docs for SQL Server Resource Governor
|
| introducedInVersion |
SQL Server
ⓘ
surface form:
SQL Server 2008
|
| monitoredBy | Dynamic Management Views (DMVs) ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| primaryPurpose |
control system resource consumption
ⓘ
manage SQL Server workload ⓘ |
| requires | classifier function for custom routing of sessions ⓘ |
| runsOn |
SQL Server
ⓘ
surface form:
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
ⓘ
surface form:
SQL Server 2008
SQL Server ⓘ
surface form:
SQL Server 2008 R2
SQL Server ⓘ
surface form:
SQL Server 2012
SQL Server 2014 ⓘ SQL Server ⓘ
surface form:
SQL Server 2016
SQL Server ⓘ
surface form:
SQL Server 2017
SQL Server ⓘ
surface form:
SQL Server 2019
SQL Server ⓘ
surface form:
SQL Server 2022
|
| usesConcept |
classifier function
ⓘ
resource pool ⓘ workload group ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Resource Governor Description of subject: 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.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Microsoft Docs for SQL Server Resource Governor