SQL Server 2014- Resource Governor to control I/O
Play SQL Server 2014- Resource Governor to control I/O
Have you ever come across a situation where you want to re-index complete database and other queries are facing slowness because of IO bottleneck? _x000D_ _x000D_ IOPS is certainly a point of concern for any infrastructure, especially when you are running RDBMS systems, and a way to govern IOPS will tremendously benefit the overall throughput and will help attain balanced systems. The session will cover information around what's new in SQL 2014 Resource Governor, and how to efficiently use it. _x000D_ _x000D_ Resource Governor was introduced in 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. It enables customers to implement database consolidation or to configure their own database as a service. Since then, we’ve been incrementally enhancing this feature in major releases to address the top customer requests in this area. In SQL Server 2014, we are excited to add support for IO resource governance.