Buffer Pool Extension and Resource Governor for IO

Buffer Pool Extension and Resource Governor for IO

Explore the performance-enhancing features of SQL Server 2014 in this 41-minute conference talk from PASS Data Community Summit. Learn how Buffer Pool Extension can boost OLTP application performance by extending SQL Server's buffer pool to non-volatile disks like SSDs. Discover the improved Resource Governor capabilities for better control of physical IO in SQL Server resource pools. Dive into configuration details, troubleshooting options, and changes in Dynamic Management Views (DMVs). Gain insights on XEvent and Performance Counters additions to optimize your SQL Server environment.