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
- Understand the purpose of SQL Server query optimization statistics
- Understand the use of transactions and locks
- Identify the tools that you can use to troubleshoot the performance of SQL Server Database Engine
