O'Reilly logo

SQL Server 2014 Development Essentials by Basit A. Masood-Al-Farooq

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 6. Performance Basics

There are many factors that could affect the performance of a SQL Server database, such as the server hardware, the operating system setup, and the configuration of the database. Therefore, optimizing the database performance is often considered to be one of the most difficult tasks that few understand. However, in most situations, you can achieve optimum performance with a relatively small investment of your time and by understanding how SQL Server works.

After completing this chapter, you will be able to do the following:

  • Understand the workings of the SQL Server Relational Engine
  • Understand the workings of the SQL Server 2014 in-memory engine (Hekaton)
  • Understand the use of indexes and how they optimize database performance ...

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