VirtualDiskSize parameter does not work to prevent Msg 3257

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, javen

VirtualDiskSize parameter does not work to prevent Msg 3257

Postby timh@ucn.net » Thu Sep 16, 2010 1:33 am

I followed the steps by adding the line in the Hyperbac.conf file and restarted the service. The log showed that it read the parameter but the new amount of 1500GB was not reported to SQL Server (2000 SP4). I changed the value to 100, restarted the service and the actual amount available was still reported.
timh@ucn.net
 
Posts: 3
Joined: Tue Jul 18, 2006 5:03 pm

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

Thank you for your post into the forum and sorry for the delay in replying.

I little confused by your post.

I suspect one of two things may have occurred, regarding the VirtualDiskSize parameter:

1. The value given to the VirtualDiskSize parameter is too small so a bigger value needs to be set.

OR

2. Even when you set the VirtualDiskSize parameter, the actual amount of free disk space available is still insufficient to create the database compressed files.

Another possibilty is that when you view the properties of the database, SQL still reports the files sizes as the orignal size.

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

Postby timh@ucn.net » Tue Oct 19, 2010 4:18 pm

We received a patched version and the parameter now works as stated in the documentation. The patch also took care of an issue where SQL Storage Compress was licensed but not the underlying Hyberbac which expired after two weeks.
timh@ucn.net
 
Posts: 3
Joined: Tue Jul 18, 2006 5:03 pm


Return to SQL Storage Compress 5

Who is online

Users browsing this forum: No registered users and 1 guest