Post reply

Poor Restore Performance

  • October 14, 2011 at 1:52 pm

    #245335

    I've got a server we use for conversions.

    24 Core (AMD) system 32 GB of Ram. Mirrored C:\ drive and an attached SAN drive using an XIO Emprise SAN.

    http://xiostorage.com/pdf/datasheets/XIO1054.03_emprise_sql.pdf

    I have a 2 GB database backup I'm trying to restore, the backup is on the root of C:

    When I restore the database to the C: drive it takes about 1 minute to restore, when I restore to the XIO San it's taking between 6 and 8 minutes. I'm seeing horrible performance metrics from SQLIO with regard to the SAN drive.

    I've looked at Disk alignment, cache settings on the SAN, HBA Queeu depth, wait states, and several other things I've likely forgotten by now.

    Any other ideas on what I can check to troubleshoot what seems to be a SAN issue?


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • October 14, 2011 at 2:35 pm

    #1394854

    Sector/Allocation Unit size?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

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