Not seeing the compression I would expect

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, javen

Not seeing the compression I would expect

Postby danv@people20.com » Fri Nov 12, 2010 12:31 am

I currently own SQL Backup Professional 6 and normally see a compression size of a 72GB database (52G mdf, 20GB ldf) to 29GB. Most of the compression comes from the empty space.

When I installed the Storage product and restore the SQB backup file to an mdfx and ldfx, I ended of with a 42GB total file size (ldfx was 128mb). Most of compress appears again that it's mostly due the fact that mdf has about 6GB of free space and most (if not all) of 20GB ldf is also free space. At the end of the days that means I'm only realizing 4-6GB of actual compression.

Why am I not seeing more compression from the product similar to 29GB size of the SQB file?
Dan V, P20 Global
danv@people20.com
 
Posts: 1
Joined: Mon Dec 07, 2009 3:59 pm

Postby tiestvilee » Thu Feb 24, 2011 3:02 pm

Hi Danv,

I don't quite get where you're numbers are coming from - could you clarify for me?

Original Backup File - 29GB
ldfx - 128MB
mdfx - ??MB <- should be about the same as ldfx

(If you have other ldfx/ndfx/mdfx files for this DB, please include those)

Is your mdfx ending up 42GB big? Where are you getting that number from?

Are you restoring your backup to a more recent version of SQL Server? When 'upgrading' a database like that, there end up being a lot of writes, which results in the 'upgraded' database being quite large when using SVR.
tiestvilee
 
Posts: 5
Joined: Tue Oct 12, 2010 4:49 pm


Return to SQL Storage Compress 5

Who is online

Users browsing this forum: No registered users and 0 guests