May 7, 2009 at 6:32 am
So I'm interested in your opinions on some daily metrics that can be tracked for a DBA. Our firm is interested in more and more metrics and I want our group to be able to provide some insight into our daily activities.
Any specifics that you can suggest and how to go about compiling and tracking?
Thanks!
May 7, 2009 at 6:42 am
I'll pick Space utilization and Performance; in the last case a chart showing how performance relates to SLA wouldn't hurt and, if good would make you famous among management. Well, if bad you will be also famous but for the unwanted reasons.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 7, 2009 at 7:20 am
I like to monitor long running queries so that this can be enhancement by you of the dev team (link 1).
As in the previous post you have to track your disk usage, but the add the this I monitor database growth (this then allows you to predict when additional space could/will be needed). On top if this i montior each table growth, as a number of high transactional table are in different filegroups/disk in my systems.
If you are unsure about using DMVs, there is a very good tool out there that can produce good metric reports. "Idera SQL Diagnostics Manager".
link 1
http://furrukhbaig.wordpress.com/2007/08/17/worst-performing-queries/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply