Chapter 11Optimizing SQL Server 2014
WHAT'S IN THIS CHAPTER?
- Understanding the benefits of optimizing application performance
- Using partitioning and compression to improve performance
- Tuning I/O, CPU, and memory to increase the speed of query results
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
The wrox.com code downloads for this chapter are found at www.wrox.com/go/prosql2014admin on the Download Code tab. The code is in the Chapter 11 download and individually named according to the names throughout the chapter.
Configuration is only one part of maintaining SQL Server. In every release of SQL Server, features have been added, largely to the Enterprise edition. SQL Server has additional features that, when utilized, can allow for better scale and optimization of specific areas. Partitioning, compression, buffer pool extensions, proper configuration of data files, log files, and even query parameters can all have an important effect on SQL Server's capability to function properly and efficiently.
APPLICATION OPTIMIZATION
You can squeeze more performance out of your SQL Server in many ways, and it is a good idea to ensure that the application is running optimally. Therefore, the first order of business for scaling SQL Server 2014 on the Windows Server platform is optimizing the application. If the application is not well written, getting a bigger hammer only postpones your scalability issues, rather than resolving them. In this chapter, you will read about tuning with regard ...
Get Professional Microsoft SQL Server 2014 Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
