August 14, 2013 at 1:25 pm
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
August 15, 2013 at 7:26 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy