Shipping Policy
24/7 Customer Support
Login/Register
Book an Appointment
One-Stop Shop
Quality Solutions
Dedicated Support
Fast Shipping
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.
Features:
Speaking more broadly in terms of database performance, there are several metrics you should capture both within and outside of the database. When you break down the metrics of resource utilization, you see a few different areas:- CPU utilization (server)
- Memory utilization
- Disk utilization and latency
- Networking
- Blocking/locking activity (database)