Brent Ozar tries out an update to resource governor:
We’ve finally got a way to defend ourselves. We can configure Resource Governor to divide people into groups (something that seems to be trendy lately), and then cap how much TempDB space each group can consume. You don’t even have to divide them into groups, either (take note, politicians) – you can just cap how much resources everyone can use altogether.
To keep things simple for the sake of this blog post, let’s just assume we’re limiting everyone’s usage altogether.
Click through to see how it works, as well as some of the caveats that are going to require foresight before this works the way you’ll want it to.