Hey,
A short one today, but I thought it might be nice to have some hard facts on the performance tuning I had been doing, rather than all hypotheticals.
I’m happy to report that it went very smoothly, applying two indexes, identified by Database Engine Tuning Advisor, has eliminated all timeouts, and dropped our average query time from 30 seconds, to 0.7 seconds. Oh my yes.
The disk I/O has dropped massively also. My average Disk queue/length in performance monitor was routinely maxed out at 100%, with the indexing applied it hasn’t gone above 15%.
One last example, a large select query on a report server was taking 37 minutes to return results, and was killing the SAN with I/O requests. Index applied, 36 seconds later and the results are returned, no impact to the server.
Just a short addition to last weeks article to prove that something as simple as running a trace, and letting SQL server tune your database for you, can yield massive returns.
Something to think about!