As a DBA, your top priority is to keep your databases and
dependent applications running smoothly at all times. To this
end, your best weapon is judicious monitoring of key performance
metrics. In a perfect world, you’d want to be up-to-date
regarding every aspect of your database’s activity – i.e. how
many events occurred, how big they were, precisely when they
happened and how long they took.
There certainly is no shortage of tools that can monitor resource
consumption, provide instantaneous status snapshots, and generate
wait analysis and graphs. The challenge is that some metrics can
be expensive to measure, and, perhaps even more importantly, they
can require a lot of work to analyze.
The purpose of Part-2 of the blog series is to narrow down the
field to those performance metrics that provide the most value
for the effort as well as present some tangible ways to capture
and study them. It is by tracking the most useful …[Read more]