SQL Server 2008 - Shrink vs Other Optimization After Removing Images
Posted on 2014-02-26
I have a SQL Server 2008 database that had images stored as binary data. The server started max'ing out it's 8GB of memory and I think it was largely due to the fact that it was storing images within the database (1MB size ones).
We've removed the images from the database and now store them in the filesystem and reference them by an ID in the database. I think this has helped a lot… it has also reduced the size of the database significantly as we've deleted the tables that stored the images.
My question - I was wondering if this is when using the "Shrink" Task (ie. Right Click DB in SQL Server Management Studio > Tasks > Shrink) would help or are there other issues that using Shrink can cause? Is there something else I can do to re-optimize the DB after this major change in structure? Also, what's the difference between Shrink DB and Shrink Files as far as performance.