Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456»»»

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times) Expand / Collapse
Author
Message
Posted Monday, May 5, 2008 4:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 29, 2014 12:18 PM
Points: 152, Visits: 95
Kevin,

Nice work man... going by the screenshots it seems like you had this running on UniProcessor Environment and with 1 GB RAM.

couple of questions - Any chance you have metrics on a better server? and secondly, was there anything else running on this box when you took either of the backups?

I am concerned about the spike in CPU load during the compressed backups. Seems to put quite a lot of load the box. Wondering if there are any settings to limit the compression algorithm to minimal/medium/full... etc..
Post #495341
Posted Monday, May 5, 2008 11:28 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 6:56 AM
Points: 335, Visits: 3,173
Hi

The environment was a Virtual PC - running XP SP2 with 1GB RAM.

There was no other applications running on this machine at the time of the backup.

Thanks
Kevin
Post #495394
Posted Monday, May 5, 2008 11:34 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, August 23, 2014 6:56 AM
Points: 335, Visits: 3,173
I do not have any info on a better spec'd server - but may in the near future.

I have not investigated the possibility of adjusting the compression percentage, but this would be an interesting idea.

The only things that you may save in a less compression setting is speed and CPU, but this may be required if you consider the limitations on disk speeds and CPU utilization etc

Thanks
Kevi
Post #495397
Posted Tuesday, May 6, 2008 3:46 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 2, 2012 4:52 AM
Points: 1, Visits: 23
My Test Results.

SQL 2008 w/ Compression

Size: 3.39GB
Time: 12 Mins
CPU%: AVG 40%

SQL 2008 wo/ Compression

Size: 14.0GB
Time: 21 Mins
CPU%: AVG 30%

Restore details to follow.
Post #495469
Posted Tuesday, May 6, 2008 6:00 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 3:19 AM
Points: 5,371, Visits: 1,391
Nik Southworth (5/6/2008)
My Test Results.

SQL 2008 w/ Compression

Size: 3.39GB
Time: 12 Mins
CPU%: AVG 40%

SQL 2008 wo/ Compression

Size: 14.0GB
Time: 21 Mins
CPU%: AVG 30%

Restore details to follow.



Good findings. In terms of speed and size the difference is almost more than 50%. The more big the database the more difference will come I believe. But one thing what will be the compression rate of image field?



Post #495531
Posted Tuesday, May 6, 2008 7:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:07 AM
Points: 36, Visits: 71
Be interesting to see how this compression compares to software products that already do compression, is the sql 2008 better, worse or the same ?
Post #495609
Posted Tuesday, May 6, 2008 9:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 23, 2008 2:15 PM
Points: 4, Visits: 24
Having worked with the Redgate folks for over three years now, I would say they are more interested in advancing technology and making good products for their customers, reahter than being worried about the platform.

They have been hands down, one of the 5 best vendors I have ever worked with. But one would expect no less from a bunch of Guiness swilling British engineering types!! :D
Post #495718
Posted Tuesday, May 6, 2008 11:24 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
Excellent article and and a very nice analysis of a new feature in 2008. Of course, the feature is much less impressive to people like me already using something like SQL Backup 5 which has excellent compression, but its nice to have the option available.

I would also like to join the call for similar metrics and analysis of restore. It would also be interesting to see a comparison between this and what SQL Backup 5 does in terms of speed and compression ratios.


---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #495815
Posted Tuesday, May 6, 2008 6:26 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 17, 2008 4:31 PM
Points: 31, Visits: 15
Of course SQL backup compression is great....but my understanding is that it is only available with SQL Enterprise edition - which costs a helluva lot more than Standard.

Why oh why Microsoft woudl you make something like backup compression an Enterprise only feature....I can understand the BI and analysis stuff being pared down...but not THIS
Post #496018
Posted Wednesday, May 7, 2008 2:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 29, 2010 8:07 AM
Points: 36, Visits: 71
backup compression is available in all editions.
Data compression of the online database is an enterprise only feature, which is different from backup compression.
That is what I was told at a microsoft seminar.
Post #496127
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse