© Benjamin Nevarez 2016

Benjamin Nevarez, High Performance SQL Server, 10.1007/978-1-4842-2271-3_7

7. Performance Troubleshooting

Benjamin Nevarez

(1)Santa Clarita, California, USA

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 ...

Get High Performance SQL Server: The Go Faster Book now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.