In the previous editions of SQL Server, the Resource Governor allowed you to specify the limits on the amount of CPU or memory that a process can use as part of the resource pool. In SQL Server 2014, this has now been improved with new Resource Governor settings to include the I/O activity too. In SQL Server 2014, you can use the new MIN_IOPS_PER_VOLUME
and MAX_IOPS_PER_VOLUME
settings to control the physical I/Os issued for user threads in a given resource pool.
Getting Started with SQL Server 2014 Administration
By :
Getting Started with SQL Server 2014 Administration
By:
Overview of this book
Table of Contents (13 chapters)
Getting Started with SQL Server 2014 Administration
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
SQL Server 2014 and Cloud
Backup and Restore Improvements
In-Memory Optimized Tables
Delayed Durability
AlwaysOn Availability Groups
Performance Improvements
Index
Customer Reviews