0% Compression with multiple filegroups

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, fionag

0% Compression with multiple filegroups

Postby epetro » Wed Feb 15, 2012 2:52 pm

I have reported an issue with support where, when restoring a backup containing 9 filegroups, only 1 is restored as COMPRESSED.

I have seen this work. In fact, with a backup file from the same production database worked correctly about a month ago.

Since the issue arose, I have upgraded SQL Storage Compress.
The GUI reports a version of 6.0.0.320
The log file reports HyperBac service version 5.5.1.10
The log file reports HyperBac filter version 6.0.0.15

The upgrade and required server reboot did not correct the behavior.

Here is my restore command I run against a Redgate .sqb file.
Code: Select all
RESTORE DATABASE [MYDB] FROM
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb',
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb',
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb',
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb',
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb',
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb',
DISK = N'K:\\DatabaseBAK\\MYDB\\FULL_(local)_MYDB_noUse_20120209_084922.sqb'
WITH MOVE N'EBC_Data' TO N'G:\\Database\\MYDB.mdfx',
MOVE N'EBC_Index' TO N'G:\\Database\\MYDB.ndfx',
MOVE N'EBC_ChargeActive' TO N'G:\\Database\\MYDB_ChargeActive.ndfx',
MOVE N'EBC_Transactions' TO N'G:\\Database\\MYDB_Transactions.ndfx',
MOVE N'EBC_TapeCharge' TO N'G:\\Database\\MYDB_TapeCharge.ndfx',
MOVE N'EBC_LogTables' TO N'G:\\Database\\MYDB_LogTables.ndfx',
MOVE N'EBC_TapeStaging' TO N'G:\\Database\\MYDB_TapeStaging.ndfx',
MOVE N'EBC_EBCTables' TO N'G:\\Database\\MYDB_EBCTables.ndfx',
MOVE N'EBC_Log' TO N'F:\\LogFiles\\MYDB.ldf',
STATS=1,
RECOVERY

In this scenario only the filegroup 'EBC_Index' receives the compression.
I tested a scenario where I adjust the move clause for 'EBC_Index' to native file *.ndf. The result was no compression anywhere.
I believe additional logging needs to be enabled.

Anyone know how to bump the logging level (including service/server restarts) and how much overhead is expected for 2 compressed databases?
epetro
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners

Disk to blame?

Postby epetro » Wed Feb 29, 2012 8:42 pm

I am now leaning toward our disk configuration not playing nice with SQL Storage Compress.
After receiving only 1 filegroup with compression, I switched the drive letters (was placing MDF seperate from secondary filegroups) and the inverse received compression !!

I'm not familiar with disk configurations, so I am reaching out to some co-workers.
What I gather:
HP MSA 2000 (shows up in properties as HP MSA2312fc Multi-Path Disk Device)
2 fiber ports
Partition style: GUID Partition Table(GPT)
Write caching enabled
epetro
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners


Return to SQL Storage Compress 6

Who is online

Users browsing this forum: No registered users and 0 guests