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 ...
© Benjamin Nevarez 2021
B. NevarezHigh Performance SQL Serverhttps://doi.org/10.1007/978-1-4842-6491-1_88. Performance Troubleshooting
Benjamin Nevarez1
(1)
Santa Clarita, CA, USA
Get High Performance SQL Server: Consistent Response for Mission-Critical Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
