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.
Overview
Syllabus
SQL Server 2014 Webinar Series
About PASS
PASS BUSINESS ANALYTICS CONFERENCE
Problem statement
Changes in SOL Server 2014 - Buffer Pool Extension
How Buffer Pool Extension works
Example paring the config
Configuration details
Troubleshooting options
Resource Governor Overview
DMV changes
Xevent and Performance Counters additions
Taught by
PASS Data Community Summit
