Resource Governor in SQL Server - Workload Throttling

Resource Governor in SQL Server provides CPU, Memory and I/O throttling. In SQL Server 2014 and earlier, CPU throttling works only for similar kind of workloads and not for mixed workloads, where high importance workload group gets 9 slices of CPU, medium importance gets 3 slices and low 1 slice. In SQL Server 2016, CPU throttling works fine for all kinds of workloads.

The below video demonstrates this with hands-on example. SQLTest Tool simulates the hands-on labs for you, no registration necessary. You can practice the online hands-on example while watching the video.

No access to Youtube? Watch this video on msdn Channel 9 instead!

Attend our upcoming SQL Server Performance Tuning Hands-on Workshop in London! Or check out other workshop locations ~

Subscribe to our Newsletter



Tags

AlwaysOn Availability Groups   Application Timeout   ASYNC_NETWORK_IO   Asynchronous Replica   Attention   BPE   Command Timeout   CPU Throttling   Data Compression   Data Latency   Dynamic SQL   Estimation   Execution Plan   Extended Events   Filtered statistics   In-memory OLTP   Locking   locks lock waits   Memory Optimized Table Variable   NUMA   optimize for ad hoc workloads   Optimizer   PAGELATCH_EX   PAGELATCH_SH   Parameterization   query post execution showplan   Readable Secondary   Resource Governor   Scan   Seek   sp_executesql   sp_whopro   SQL Server   SQLTest   Stored Procedure   Synchronous Replica   Table Variable   Temp Table Caching   Tempdb   Tempdb Allocation Contention   Tempdb Metadata Contention   Temporary Table   Wait Stats   Workload Throttling  

VISIT ALSO OUR SISTER PAGES