Post reply

How to do proper tuning

  • March 28, 2011 at 1:35 am

    #389151

    Hi all experts!

    I have a machine that needs to be tuned perfectly.

    My questions: Are there any good sources/ebooks how to do this from the start?

    We don't have any performance issues right now, but we need the perfect setup.

    Any tip?

    Thanks!

  • March 28, 2011 at 2:30 am

    #1304207

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 28, 2011 at 10:10 am

    #1304463

    mattias 58533 (3/28/2011)

    Hi all experts!

    I have a machine that needs to be tuned perfectly.

    My questions: Are there any good sources/ebooks how to do this from the start?

    We don't have any performance issues right now, but we need the perfect setup.

    Any tip?

    Thanks!

    Get an experienced tuning consultant and let him/her have a look at the setup.

    The two statements "tuned perfectly" and "how to do this from the start" don't match very well... 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • March 28, 2011 at 10:28 am

    #1304468

    LutzM (3/28/2011)

    mattias 58533 (3/28/2011)

    Hi all experts!

    I have a machine that needs to be tuned perfectly.

    My questions: Are there any good sources/ebooks how to do this from the start?

    We don't have any performance issues right now, but we need the perfect setup.

    Any tip?

    Thanks!

    Get an experienced tuning consultant and let him/her have a look at the setup.

    The two statements "tuned perfectly" and "how to do this from the start" don't match very well... 😉

    Dito here... takes years to truly master this art. You can get pretty far on this road by yourself if you're willing to put in the hours, but competent, hired will definitly will...

  • March 29, 2011 at 9:13 am

    #1304939

    Put me down as +3 for hiring a performance tuning expert to both review your systems/applications and make recommendations as well as mentor you on how to go about keeping an eye on things and responding to future tuning needs. Win-Win-Win!

    It is SUCH a complex, multivariant space that it is inconceivable that you could become even moderately good at it in less than a year or so of dedicated learning, training, working. Mentoring from a pro will get you a long way much more quickly while also helping you avoid the disasterous outcomes that often arise from having "a little knowledge". 😎

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

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

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