GilaMonster (5/9/2013)
Kill no.As for how it works, it would take a few pages to explain, so maybe have a read through the entries in BoL (there's a load of information) and post any specific questions.
Doing that right now. I've heard about it before, but have not implemented on any of my production boxes yet.
However, not so sure if will do the trick. As the issue with those ad-hoc queries is more IO and elapsed time than CPU or RAM. It is my understanding that resource governor is more focused on RAM and CPU resources.