Abstract
This chapter dicusses 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 3. I am sure the Query Store will be the main tool for query performance troubleshooting starting with SQL Server 2016. In addition to query performance, there are many performance items that do not fall into the query troubleshooting category, or if you are not yet in SQL Server 2016, there are alternate ways to troubleshoot queries.
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
© 2016 Benjamin Nevarez
About this chapter
Cite this chapter
Nevarez, B. (2016). Performance Troubleshooting. In: High Performance SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-2271-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4842-2271-3_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-2270-6
Online ISBN: 978-1-4842-2271-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books