Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kevin van der Merwe SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times) RE: SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes & Times)

  • May 5, 2008 at 4:49 pm

    #810978

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