Red Gate forums :: View topic - 0% Compression with multiple filegroups
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Storage Compress 6
SQL Storage Compress 6 forum

0% Compression with multiple filegroups

Search in SQL Storage Compress 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Wed Feb 15, 2012 2:52 pm    Post subject: 0% Compression with multiple filegroups Reply with quote

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:
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?
Back to top
View user's profile Send private message
epetro



Joined: 31 May 2011
Posts: 55
Location: Zotec Partners

PostPosted: Wed Feb 29, 2012 8:42 pm    Post subject: Disk to blame? Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group