Charles Kincaid (5/4/2015)
Thanks Gail. I had missed that point.Toby, the O/S fragmentation does not have anything to do with the shrink. Actually it does not even apply to index fragmentation. I'm am slightly less concerned about a blanket rebuild of indexes as I am about blanket shrinks.
A perpetual shrink will cause a perpetual need for the database to regrow. Those growths will cause on-disk fragmentation as the new file segments are being placed on whichever portion of the disk becomes available at that time.
On disk fragmentation can be an issue for performance as well.
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