From the course: Advanced SQL for Application Development

Unlock the full course today

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

Monitoring and logging best practices

Monitoring and logging best practices

From the course: Advanced SQL for Application Development

Start my 1-month free trial

Monitoring and logging best practices

“

- [Instructor] Now, another area that we want to consider, when we're thinking in terms of reliability, is monitoring and logging. Now, there are several reasons why we want to monitor and log events that are happening in our database and database applications. First of all, we want to just understand resource allocation. How are we utilizing CPU's, and discs and Network resources? Because the more we understand about that, the more we can better plan for capacity that we'll need in the future. And, it's also important to help us diagnose problems. So, ideally, we will avoid problems by doing things like allocating enough resources before we actually need them. But, as we've seen before, with Connection Pools and other resources, problems are going to crop up so we want to make sure we have as much information available to us when those problems occur, so that we can find the root cause of the problem and get the system…

Contents