Fred Williams-487170 (4/13/2011)
Thanks for the article but can you supply some performance measurements to quantify the benefits of making those changes?
Otherwise statements like this:
" Just think of the resource hit (over time) the database took each time it grew, and think of all the physical file fragmentation this has contributed to, further hurting performance."
are just too subjective to really be helpful..
Since this is after the fact, and the previous data doesn't exist for SSC, I can't tell you the actual performance hit. On the other hand, when I have time, perhaps I can put together a test and write up the results to demonstrate my point.
Brad M. McGehee