From the course: Designing Highly Scalable and Highly Available SQL Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Monitoring relational databases

Monitoring relational databases

From the course: Designing Highly Scalable and Highly Available SQL Databases

Start my 1-month free trial

Monitoring relational databases

“

- [Instructor] Yeah, part of maintaining and realizing highly scalable databases and highly available databases is having really well-established monitoring in place. Now, there are a number of things we really want to pay attention to. Now, an obvious one is resource consumption. If our memory utilization and CPU utilization is always maxing out, then we're probably not getting the throughput that we would expect. So we want to make sure we watch those resources. We also want to know what queries are essentially taking the most time, because that translates into taking the most resources. So understanding the top uses of our resources in terms of queries will allow us to be able to identify those and then tune them appropriately. We also want to keep an eye on our throughput, which is basically how much work are we getting done? Now this is, of course, going to vary by application and the loads on the database, but in…

Contents