Data Platform

Laying Down the Law with SQL Server Resource Governor

Windows B July 21, 2018 11:40 am - 12:40 pm

Bookmark and Share

Lonny Niederstadt

Interactive business workloads, batch workloads and administrator activity often overlap.
Resource Governor is a SQL Server tool for tracking and provisioning resources which can be used to great effect in traditional on-premise systems, virtualized systems, and in the cloud.

In this session, we’ll explore various strategies for Resource Governor classification functions.
With demos and design discussion, we’ll look at how Resource Governor can affect utilization of memory, CPU and disk resources. Real world examples of increased query concurrency and improved performance will be detailed.