May 20, 2014 at 10:21 am
Hello all. We are looking for a way to report database performance to upper management. I'll start by giving you an overview of our team structure. I manage a team of various roles: Level 2 support specialists, configuration managers, and DBAs - we are dubbed the "Production Support Team". I report directly to the VP of Software Development who oversees the Design, DEV, and QA, team managers. This means that our team, Production Support, can be considered a peer team of Design, DEV, and QA.
The manager of each team compiles metrics from their team members and reviews them on a weekly basis to ensure we are headed in the right direction. We then take our metrics, and distill them down into a few key metrics that we then report to the VP of Software Development. Those metrics are easy tom compile for the L2 support roles (number of tickets escalated, number closed, etc.). However, I've been struggling with how to report DBA performance for a long time. Every time I start to compile numbers, I end up with tons of things that are great for a DBA, but don't mean much to upper management. Does anyone have any suggestions Surely I'm not the only person that has had this issue?
I'd be happy to provide more info if needed. Thanks!
May 20, 2014 at 10:41 am
Clint-525719 (5/20/2014)
Hello all. We are looking for a way to report database performance to upper management. I'll start by giving you an overview of our team structure. I manage a team of various roles: Level 2 support specialists, configuration managers, and DBAs - we are dubbed the "Production Support Team". I report directly to the VP of Software Development who oversees the Design, DEV, and QA, team managers. This means that our team, Production Support, can be considered a peer team of Design, DEV, and QA.The manager of each team compiles metrics from their team members and reviews them on a weekly basis to ensure we are headed in the right direction. We then take our metrics, and distill them down into a few key metrics that we then report to the VP of Software Development. Those metrics are easy tom compile for the L2 support roles (number of tickets escalated, number closed, etc.). However, I've been struggling with how to report DBA performance for a long time. Every time I start to compile numbers, I end up with tons of things that are great for a DBA, but don't mean much to upper management. Does anyone have any suggestions Surely I'm not the only person that has had this issue?
I'd be happy to provide more info if needed. Thanks!
Which are you interested in? DBA or Database?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2014 at 2:58 pm
Sorry for the confusion. I am trying to report database performance.
May 20, 2014 at 4:28 pm
In that case, it really boils down to knowing your boss and your environment. Which metrics do you feel are important vs. which are important to the boss? Find the overlap and include some of the metrics you feel are important and explain to him/her why they are important.
Not every boss cares to see the same metrics for performance. A lot of it is noise to them. Finding high level performance indicators, disk usage, cpu information, transactions/second are things that work well to bubble up to management. Then it is a matter of finding what else will help them to better understand the environment and what you are doing for them.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 21, 2014 at 10:58 am
I would have thought senior management would be interested in throughput figures - so disk latency, disk sec\read, disk sec\write, response times for queries (end to end), what percentage are sub second etc. If you have an SLA on response times, how many meet the target.
On top of that its a numbers game, databases supported, transactions per sec handled, with that related to say customer transactions handled if thats relevant for your systems.
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply