| Author |
Message |
epetro
Joined: 31 May 2011
Posts: 55
Location: Zotec Partners
|
 Posted: Wed Feb 15, 2012 2:52 pm Post subject: 0% Compression with multiple filegroups |
 |
|
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 |
|
 |
epetro
Joined: 31 May 2011
Posts: 55
Location: Zotec Partners
|
| Posted: Wed Feb 29, 2012 8:42 pm Post subject: Disk to blame? |
|
|
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 |
|
|
|
|
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
