always on sql server 2012 Hybrid Storage

  • Good afternoon,

    What are the implications for the always on, have the primary with disk SSD and secondary with HDD SAS?

    thank you very much

    Michael Antunes

  • Nothing really. The secondary will be somewhat slower for I/O. If you have synchronous calls that might cause some problems. Async calls will work the way they're intended. In general, to a degree, this is the idea behind the shared nothing approach. You don't have to have all the very best hardware duplicated in order to have a high availability solution.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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