Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to report database performance to upper management Expand / Collapse
Author
Message
Posted Tuesday, May 20, 2014 10:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:56 PM
Points: 80, Visits: 458
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!
Post #1572785
Posted Tuesday, May 20, 2014 10:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:48 PM
Points: 21,251, Visits: 14,959
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1572792
Posted Tuesday, May 20, 2014 2:58 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:56 PM
Points: 80, Visits: 458
Sorry for the confusion. I am trying to report database performance.
Post #1572919
Posted Tuesday, May 20, 2014 4:28 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:48 PM
Points: 21,251, Visits: 14,959
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1572944
Posted Wednesday, May 21, 2014 10:58 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:21 PM
Points: 5,975, Visits: 12,883
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.


---------------------------------------------------------------------

Post #1573270
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse