Setting SQL Server Performance Baselines and Alerts


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

Kevin Kline

Kevin Kline

Principal Program Manager

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. As a noted leader in the IT industry, Kevin's blog covers Microsoft SQL Server features and best practices, third-party software, trends in the IT industry, and professional development for IT professionals.

Richard Douglas

Richard Douglas

Principal Solutions Engineer

Richard (@SQLRich) is a Principal Solutions Engineer at SentryOne, specializing in our SQL Server portfolio offering in EMEA. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community; previously he ran a PASS Chapter in the UK and served on the organizing committee for SQLRelay.

Companies with the highest demands for database performance choose SentryOne