Post reply

Performance Goals

  • January 2, 2011 at 7:40 am

    #149632

    Hi

    I was just wondering what would be the perforamnce golas in general for a DBA, I was doing all contracy jobs before where i was not worried about any performance review but recently i took up a full time job and now i need to present perforamnce review.

    Could someone list me what goals a DBA can present in general which are specific and has measurement to it.

    Any thoughts on this are greatly appreciated. Thanks

  • January 3, 2011 at 6:30 am

    #1268438

    As fast as possible.

    OK, maybe not. Usually it's initially set by the business, not by the DBA's. There's going to be a threshold above which your users begin to complain. That's your goal. Not "as fast as possible." The best approach is to do an initial assessment of your system to determine where your performance problems lie. Are they in app code, tsql, indexing, table structures, server, or all of the above? With the knowledge of where the slow parts are, talk to your business. Ask them if they're satisfied with current performance. If not, show where you can improve performance and how much work it will take. They'll then negotiate with you in regards to what gets done first.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 3, 2011 at 6:47 am

    #1268456

    Heh... Grant. Spoken like a true DBA but that's not the type of "performance goals" being talked about here. It's the ol' "fill-in-your-own-evaluation-because-your-manager-doesn't-know-how-to-evaluate-you" time again. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 3, 2011 at 6:51 am

    #1268458

    Tara-1044200 (1/2/2011)

    Hi

    I was just wondering what would be the perforamnce golas in general for a DBA, I was doing all contracy jobs before where i was not worried about any performance review but recently i took up a full time job and now i need to present perforamnce review.

    Could someone list me what goals a DBA can present in general which are specific and has measurement to it.

    Any thoughts on this are greatly appreciated. Thanks

    Mine has been the same for roughly 10 years now... try to stop swearing outloud managers, users, developers, and 3rd party data providers. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 3, 2011 at 7:08 am

    #1268466

    OH!

    Silly me.

    That's harder. In general, how well did you do on reactive support? How well did you do being proactive, eliminating reactive support calls (meaning, if you ran out of space on a server, twice in a week, did you do something about it to make sure that you didn't run out twice every week for six months)? After that, usually, for me, I have a number of projects I'm either supporting or running, and I get measured on how well those are completed.

    If you have to write your own review, identify some stuff that you need to do better and how you plan on doing it. That always gets managers excited.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply