Abstract
This chapter discusses what information to look for when troubleshooting SQL Server performance problems, both examining real-time data and collecting information for later analysis. Performance information in SQL Server is exposed in several ways, and different tools are usually used to either see or collect that data. One of the new and very promising tools, the Query Store, was fully explained in Chapter 6. I am sure the Query Store will become the main tool for query performance troubleshooting for SQL Server 2016 and above. In addition to query performance, there are many performance areas that do not fall into the query troubleshooting category.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2021 Benjamin Nevarez
About this chapter
Cite this chapter
Nevarez, B. (2021). Performance Troubleshooting. In: High Performance SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6491-1_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6491-1_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6490-4
Online ISBN: 978-1-4842-6491-1
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)