4 cores as clustering in SQL can only run active on one server. it can make no use of the 4 cores in the other node until it is failed...

No, but I have looked into it. Why not look at always on AG? I just don't like having to add third party stuff into the environment having to run...

Just a thought as I haven't upgraded to SP3 yet. Have you run the SP3 installer on your PC to apply any fixes and patches to the local SSMS install?

What are the agreed SLAs with the business? With that information you can start to build a system to support their expectations and requirements.

Just be careful manually configuring modern arrays like that. They aren't really designed for it and you could heavily impact availability. These arrays do a lot of Magic spreading out...

We just recently replaced two SANs with some 3par arrays.

Most SANs these days seem to work with the disk pooling method as it does seem to provide generally good overall...

Have you done testing?

https://www.sqlskills.com/help/accidental-dba/

So you have Windows server failover clustering, running a clustered instance of SQL? The default config for SQL seems to be 1 failover in a 6 hour period. and for...

Depends on the business requirements?

If they are happy with up to 24 hours data missing just restore your nightly backups to another server? If they want close to live always...

Hi Perry, I'm not sure where would be more appropriate to post this question? the SQL 2012 section doesn't have a HA section?

This is a plain Jane two node cluster...

Anyone ever had an issue with Windows 2012 R2 clustering where it says that a server is missing windows updates but manualling checking and trying to reinstall shows the updates...

To clarify, I'm not interested in the "read intend" offload feature. More those that need access to a DB for reporting will be told to directly connect to the replica...

Is building an AG on top of the FCI as easy to roll back as it is to implement?

We plan to migrate to our new cluster in two and a...

We have plenty of SQL 2008 r2 enterprise license which our MS licensing rep has told me via software assurance we can upgrade to SQL2012/14 licenses as long as the...