Gaining Performance Insights for SQL Server
Database engines like SQL Server or Azure SQL Database are very heavily instrumented pieces of software. SQL Server tracks a multitude of internal and operating system metrics, down to the level of tracking which each thread is waiting on and aggregating the data. Starting in recent versions of SQL Server, query execution and performance are tracked in stored in a feature called the Query Store. Many advanced DBAs have a toolkit of scripts they use to help them glean insights from the large amounts of performance data in SQL Server, however, newer or accidental DBAs may need some help making heads or tails of this data. In this post, you’ll learn about a methodology for troubleshooting performance on a server, and where and what to look for.