What's been everyone's experience with the SQL Server 2014 resource governor?
I'm looking at some reporting database servers that server a set of clients. Occasionally, one client will run reports that use an excessive amount of CPU resources on the server and run a long time. This, in turn, harms the performance for the other clients on the same server.
For a situation such as this, I'm wondering if the resource governor would be a good solution. Perhaps CPU resources based on a specific database or login could be limited to no more than 40% of the server capacity.