I'm in the process of upgrading our small SQL databases to SQL Server 2012. We have at least 3 instances, (1) Critical work databases, (2) low-importance System Maintenance databases, (3) WSUS.
Can I specify a priority with which these instances run?
ie, the Critical databases should run at normal priority. During resource contention they should respond the fastest at all times.
The System Maintenance databases don't include anything the user directly sees, ie system reporting, anti virus, outbound e-mail relay, and should have a Below Normal priority. I don't care if sql queries take twice as long, I don't want it to compete with the critical databases.
What's the best way to implement this?