Compressed vs. uncompressed sizes

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, javen

Compressed vs. uncompressed sizes

Postby lfagetti » Thu Sep 16, 2010 9:49 pm

Hello,
all SQL based commands are showing the uncompressed size.
Only way I see to check compressed size (real allocated disk space) with Db files open is to check the files properties on the drive.
Any other way?
Thanks!
lfagetti
 
Posts: 13
Joined: Thu Mar 30, 2006 5:36 pm

Postby eddie davis » Wed Sep 29, 2010 3:13 pm

Thank you for your post into the forum.

SQL Server is totally unaware of SQL Storage Compress or HyperBac processes being performed on the database files. So SQL Server will always believe that the database file sizes are the real uncompressed sizes.

The only to check the actual compressed file sizes is to look at the properties for the actual files.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Compressed sizes

Postby cnilsson » Fri Jun 17, 2011 9:20 am

You could always use xp_cmdshell and DIR from within SQL to view the sizes of the files on disk.
cnilsson
 
Posts: 6
Joined: Wed Sep 16, 2009 2:37 am


Return to SQL Storage Compress 5

Who is online

Users browsing this forum: No registered users and 0 guests