Statements (52)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:Database_Management_System
|
| gptkbp:allows |
max CPU usage
max_memory_usage |
| gptkbp:benefits |
resource-intensive applications
|
| gptkbp:classification |
incoming sessions
|
| gptkbp:controls |
SQL_Server_workload
|
| gptkbp:createdBy |
resource pools
workload groups |
| gptkbp:designedFor |
gptkb:SQL_Server
|
| gptkbp:enables |
at runtime
workload classification |
| gptkbp:engineConfiguration |
gptkb:SQL_Server_Management_Studio
enforce_limits |
| gptkbp:features |
gptkb:Microsoft_SQL_Server
|
| https://www.w3.org/2000/01/rdf-schema#label |
Resource Governor
|
| gptkbp:includes |
query performance
|
| gptkbp:is_a_key_component_of |
SQL_Server_architecture
|
| gptkbp:is_a_tool_for |
performance tuning
|
| gptkbp:is_designed_to |
enhance scalability
|
| gptkbp:is_essential_for |
enterprise applications
high availability systems |
| gptkbp:is_governed_by |
system administrators
|
| gptkbp:is_integrated_with |
Azure SQL Database
|
| gptkbp:is_part_of |
gptkb:SQL_Server_2019
gptkb:SQL_Server_2012 gptkb:SQL_Server_2016 gptkb:SQL_Server_2017 SQL Server 2008 SQL Server 2014 |
| gptkbp:is_recognized_for |
T-SQL
|
| gptkbp:is_used_in |
cloud environments
improve performance reduce latency DBAs isolate workloads manage user sessions balance workloads control I/O operations control resource consumption create custom resource policies define resource limits enforce resource quotas manage concurrent requests manage disk space prevent resource contention prioritize workloads |
| gptkbp:manages |
resource allocation
|
| gptkbp:provides |
resource pools
|
| gptkbp:suitableFor |
multi-tenant environments
|
| gptkbp:supports |
memory management
CPU_management |
| gptkbp:visitedBy |
resource usage
|