February 7, 2018 at 10:52 am
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.
February 8, 2018 at 4:52 am
Yeah, you've pretty much nailed the reason for it existing. The only trick is, can you readily isolate individuals within your system to limit them logically. If so, it works great. If everyone comes in with the same login, or worse, they're all SA, you're in trouble. Or, if they all come in with the same login, everyone gets the same restrictions. However, it works. Yes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply