Post reply

Benchmarking

  • November 1, 2007 at 2:45 am

    #119247

    Right get ready to laugh but my company has 10 SQL servers but no DB, or in fact anyone approaching a DB. SO I have taken it on myself to have a look around having had some experience before, But please go easy on the answers as my SQL knowledge is more from a dev’s point of view. I have run DBCC SHOWCONTIG

    And most my tables have a scan density of between 10%-50%. I thought higher was better so straight of this looked very bad. I am I right?

    Logical and extend fragmentation average say 30% and 70%. I thought these where meant to be low like 0% I am I right?

    I have run DBCC DBREINDEX on all tables and seen density’s of around 100% and fragmentation reduced to near zero levels. I think this is a good thing?

    But how to convince the boss that DB’s need care and attention, I need a hard hitting facts like the DB is now 20% faster because some time and effort was spent on the DB. Wouldn’t it be great if we had A DBA think what they could do!!!

    But I have no idea how to bench mark the before and after I have found loads of performance tips but I cant find out how to rate these performances with simple before and after reports.

    Many thanks

  • November 1, 2007 at 5:27 pm

    #747565

    Not sure I'd waste my time benchmarking for that...

    Why not just Google a bunch of articles about SQL Server Maintenance... lot's of them say "why"...

    --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)

  • November 2, 2007 at 4:44 am

    #747678

    Stats like those quoted may only be an issue in the context of the size and importance of the databases...which you have left out. 2MB not an issue, 2TB welcome to Amityville:)

    A better angle for a arguement for a formal DBA would be security and the prospects for the whole business when the DB's goes belly up. Quite often the financial director will understand the cost of complete business failure better than the newbie management grunt.

  • November 2, 2007 at 6:02 am

    #747707

    well this is the problem i know my manager explaining what improvements could be made will not impress him. As far as he is concerned he thinks everythings okay despite the fact the users are complaining. He seems to view them as a bit of a pain. Unfortunately he is a simple man I need simple to understand figures for him. I can spend days undertaking maintance but he will not be impressed unless i can give him easy figures at the end like the DB is 10% faster etc.

    many thanks

  • November 2, 2007 at 6:33 am

    #747715

    Edward (11/2/2007)

    well this is the problem i know my manager explaining what improvements could be made will not impress him. As far as he is concerned he thinks everythings okay despite the fact the users are complaining. He seems to view them as a bit of a pain. Unfortunately he is a simple man I need simple to understand figures for him. I can spend days undertaking maintance but he will not be impressed unless i can give him easy figures at the end like the DB is 10% faster etc.

    many thanks

    Ask the users to keep a log of their complaints, then apply your maintenance, and compare their complaint logs before and after e.g. number, frequency, and types of complaints. If the maintenance reduces complaints that might impress your manager.

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

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