Summary:
Ensuring peak performance for a SQL Server instance isn’t always easy and can require a lot of work on the part of the DBA.
To maintain optimal database performance, you need to make sure you’re monitoring the right performance metrics on a regular basis. Using those metrics, you can determine what “normal” database performance looks like for most workloads. After all, when troubleshooting, you can’t tell what is abnormal if you don’t know what’s normal.
So how do you know what performance information to track and how to interpret it?
Baseline comparisons can help.
You will learn:
- About key metrics that quantitatively define the performance baseline for a SQL Server instance
- How to collect baseline data and compare and alert when performance metrics are outside of what you have defined as “normal”
- How to conduct an actual database benchmark with free, open-source tools utilizing the TPC format
Baselining is a skill that separates junior DBAs from senior DBAs. Take advantage of the opportunity to learn this important skill today!
Interested in additional SentryOne webinars? Check our webinar library.
Available On Demand
