• You could look into utilising resource governor (built into SQL) for this very situation

    🙂

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk