Just wondering, other than the effect of making the database smaller, how does the shrink call affect actual performance?  Should I expect an performance increase after it is done?  Thanks.
~piroGenerally all shrink does it reduce the size of the database files, no real performance gain as far as I know.  You have to ask your self why did they grow to that size in the first place, before shrinking them as it is a performance hit when they have to grow again.|||Thank you for replying.  
So there really is no performance decrease when I shrink the database.  The performance hit will come from db growth, which is normal.  Do you know of any other commands or functions that are similar to Access's compact command?
~piro|||Not sure what Access's compact command does, but DBCC SHRINKDATABASE can move all data to contiguous pages and remove any remaining unused space. This has the potential of reducing I/O since you would need to read fewer pages to access all data.|||Good point, forgot about the moving of data pages.
 
No comments:
Post a Comment