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

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Monitoring relational databases

Monitoring relational databases - SQL Tutorial

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

Start my 1-month free trial Buy for my team

Monitoring relational databases

“

- [Presenter] Database monitoring is really a important, and I would say crucial part of maintaining databases. And so database monitoring really comes into play after we've spent a lot of time doing our data modeling, doing our both logical and physical modeling. We've implemented databases, we've developed applications, we've deployed the application and the database, and it's basically in production. So we've done a significant amount of work to get there. Well, now we have to shift gears a little bit and start making sure that we have sufficient monitoring in place so that we can identify when there are problems that are cropping up, say, in production. Now we want to look for different things when we do database monitoring. One is resource consumption. So we want to know, for example, are we maxing out our CPUs? Are our disks filling up? So we want to be able to monitor trends. For example, how fast is our disk space filling up so that we are able to add additional storage as…

Contents