Backup duration extended for compressed databases (4x)

Silent data compression to optimize SQL Server Storage

Moderators: eddie davis, Colin Millerchip, fionag

Backup duration extended for compressed databases (4x)

Postby epetro » Mon Aug 22, 2011 8:34 pm

We have been running 5 compressed databases since 8/1 .
Our weekly RedGate backup job used to process between 22 - 43 minutes. It now requires 140 - 204 minutes.

We are not running verify.
All disk configurations have remained the same.
No changes in database access (i.e. testing during backup window).

So...
Should I be switching this server to using HyperBac 5 rather than SQL Backup 6 ?
epetro
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners

Postby peter.peart » Thu Aug 25, 2011 7:14 pm

Thanks for your post.

It would be good to take a look at the SQL Backup logs to see what sort of throughput you were getting on the normal database when performing a backup versus what sort of throughput you are getting now.

If there's a significant drop from when you had the DB running normally to running under Storage Compress, we would probably have to do some testing here and then learn a bit more about your environment, i.e. was the DB also being updated during the backup being taken on the DB running under Storage Compress, and it would also be good to get an idea of I/O reads and writes from both the HyperBacSrv.exe and SQBCoreService.exe through Task Manager.

Of course, you could also try backing up using *.HBC file format to see if you experience a better or similar performance too, but it's not a known issue at the moment with that as a workaround.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Thread owner update

Postby epetro » Mon Feb 06, 2012 4:13 pm

We have purchased and installed SQL Storage Compress 6.0.0.320 on our QA server. I have 2 compressed databases on same disks as their non-compressed counterpart.
The backups are performing at a similar rate (132MB/sec to 136MB/sec).

I will post another update as we continue to convert existing databases to a compressed solution. Perhaps having 5 compressed databases found a bottleneck in the other server or unknown factors are to blame.
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