Red Gate forums :: View topic - Backup duration extended for compressed databases (4x)
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

Backup duration extended for compressed databases (4x)

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: Mon Aug 22, 2011 8:34 pm    Post subject: Backup duration extended for compressed databases (4x) Reply with quote

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 ?
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Aug 25, 2011 7:14 pm    Post subject: Reply with quote

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



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

PostPosted: Mon Feb 06, 2012 4:13 pm    Post subject: Thread owner update Reply with quote

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.
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