O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required