Post reply

Slower backups on SAN Volumes

  • February 22, 2011 at 2:51 am

    #388909

    Hi,

    we recently migrated over 5TB of data from local disks to SAN Volumes for a single server. It has become apparent that the Lightspeed backup times have significantly increased.

    Do we need to check/make any changes to the lightspeed settings or some other changes?

    HDS SAN Volumes.

    SQL Server 2005 SP3 CU4

    thanks

  • February 22, 2011 at 5:07 am

    #1289776

    Are you experiencing same as posted below......

    Currently using Litespeed for backup of 1TB+ database, which compresses down to 103GB within 2hrs, which is pretty good. Depending on your RTO, this may fit or may not, but if your requirement is shorter and your database infrastructure is supported by a SAN, you should look at using SAN vendor Snapshot technology, which works at the block level for backups and restores.

    Hope this helps,

    Phillip Cox

    Discussion on this thread http://qa.sqlservercentral.com/Forums/Topic449096-357-1.aspx

    Cheers

    Sat

    Cheer Satish 🙂

  • February 24, 2011 at 1:51 am

    #1290773

    thanks,

    however this is not what we are experiencing.

    We are trying to understand why Lite Speed backups on the Local disks where much faster. But once we move to much faster SAN drives, they are slower?

  • February 24, 2011 at 2:44 am

    #1290799

    Could try measuring the read throughput and write throughput individually, as described here.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

  • February 24, 2011 at 2:53 am

    #1290801

    Thanks, will look into this.

  • February 24, 2011 at 3:51 am

    #1290835

    Where is (and was) the backup file being written? Was the backup to local drives as well? Is the current backup to SAN or another server? Perhaps a routing issue on the network or is it "local"?

  • February 24, 2011 at 4:00 am

    #1290839

    The backup files where written to its own local disk (external array attached to the server), SAN Luns where presented to the server, data Robo copied across, Local drives removed.

    The server still retains individual drives for data, Logs and backup, but are now SAN hosted. Database performance is now better than it was before, it's just the Lite speed timings have increased.

    thanks

  • February 24, 2011 at 4:11 am

    #1290844

    Is the backup drive a "shared" backup drive, so multiple backups being written at the same time?

    I would be looking at the SAN backup drive as the bottleneck.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply