Performance Tuning Methodology

  • One thing everyone seems to leave out, listen to your users. Yes, tuning a stored procedure to shave .05 that only takes 0.2 seconds to complete and is called 40 times per second may be great savings, but tuning code behind various pages of web app used by a critical department may buy you even more.

  • Users - BAHHH!!! Who needs 'em?!? 😀

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • TheSQLGuru (7/2/2014)


    Users - BAHHH!!! Who needs 'em?!? 😀

    Yea, our databases would perform so much better without them! :w00t:

  • Lynn Pettis (7/2/2014)


    TheSQLGuru (7/2/2014)


    Users - BAHHH!!! Who needs 'em?!? 😀

    Yea, our databases would perform so much better without them! :w00t:

    And the queries would run even faster if we could just get rid of the data.

    "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

  • Grant Fritchey (7/2/2014)


    Lynn Pettis (7/2/2014)


    TheSQLGuru (7/2/2014)


    Users - BAHHH!!! Who needs 'em?!? 😀

    Yea, our databases would perform so much better without them! :w00t:

    And the queries would run even faster if we could just get rid of the data.

    As Emperor Joseph II said in Amadeus: "there are simply too many notes, that's all. Just cut a few and it will be perfect." :hehe:

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 5 posts - 16 through 19 (of 19 total)

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