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 ...
© Benjamin Nevarez 2016
Benjamin Nevarez, High Performance SQL Server, 10.1007/978-1-4842-2271-3_7
7. Performance Troubleshooting
(1)Santa Clarita, California, USA