I'd like to ask for some quick opinions on a potential SQL installation.
Microsoft OS (preferably 2012 R2)
MS SQL (2012 or 2014 preferred)
Multiple large (enterprise level) databases across multiple SQL instances on the same server.
processing occurs 24/7, with data flowing both in and out of SQL.
some processing/queries can take several days to complete (even on reasonable spec hardware)
multiple sites are available with high capacity links between them
budget is significant so please consider all options within reason
a) How would you protect the majority of databases/instances and maintain performance when a single instance/database is under particularly HEAVY load?
b) how would you recommend planning high-availability, while keeping 'a' in mind, above when load is significant?
In HA environments, can one server handle the heavy load while other server(s) handle the normal load? how would you achieve this? is it automatic or manual?
What throttling is available? does it require manual intervention? Does it work in active/active clusters?
A single instance/database per server wouldn't be practical