We went through a similar thing when we upgraded from 2005 to 2012 on all new hardware. We went from 128GB of RAM to 256G. We went from 16 CPU core to 32. We went for just standard cache to monster 3TB cache that holds ALL of the databases on our main server.
What did we get for all that effort? We saw mostly little to no change in performance on anything having to do with the GUI (as I expected because of the singleton lookup nature of GUI code) and only a couple of "nightly runs" saw an improvement and that was only 2X in performance (which is also what I expected). Save none, everyone but me was thrilled with the occasional 2X in performance.
We just got done writing some of the nightly run code, We were actually able to do in only 600 lines of set based code what our predecessors took thousand of lines of code to do. Without too much effort, it now runs at 70X. You can't buy hardware to do that.
Performance is in the code and you're not always going to get your way for hardware. Instead of copping out because of hardware, you should have stayed and fixed all the bad code because that's where the real performance is.
is pronounced ree-bar and is a Modenism for R
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs