Mind Your IO: Resource Governor Shows You How

Sign in to queue

Description

Resource Governor was introduced in Microsoft SQL Server 2008 to achieve predictable performance in a multi-tenant environment, to support mixed workload patterns, to provide mechanisms and tools to deal with runaway queries, and to enforce resource limits for CPU and memory. In prior releases, there have been incremental enhancements to this feature. SQL Server 2014 now supports resource governance for IO. In this demo-heavy session, learn to implement Resource Governor to configure resource limits in a comprehensive manner including IO and guarantee predictable performance for different tenants. Along the way, you are also going to see enhancements to Extended Events framework and disk specific counters that have been added SQL Server: Resource Pool Stats.
For more information, check out this course on Microsoft Virtual Academy:

Day:

4

Session Type:

Breakout

Code:

DBI-B310

Room:

Room 360A

Embed

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents