• Jeff Moden (4/5/2014)


    So, yeah... I agree... hardware and hardware tuning are important but, if you really want to make an improvement, remember what most people won't even consider because hardware is supposedly cheaper than talent (and, in the long run, it's not really)... "Performance is in the code".

    While I agree, the real problem that I have seen is in dealing with Vendor code. You can't fix it without violating the terms of the contract and they refuse to fix it. So now you are stuck with finding ways of performance tuning something else. In one recent case, the best solution came down to adding disk space and short stroking the IO. By reducing the used space from 90% on the SAN down to 80%, we were able to double performance. Granted, that wasn't good enough still - but it helped.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events