October 23, 2009 at 10:07 am
Hi I setup resource governor pool to throttle a specific user to 10% cpu.
What I have found is it will only throttle that user if sql server decides there is a resource contention. I am looking for a good article that explains this. My initial impression was if I set it to 10% any adhoc sql under that id would throttle at exactly 10% but that is not the case.
I see it fluctuate around 10% and if it is the only thing running it will peg to 100%?
Any info supporting this would be appreciated.
October 23, 2009 at 10:26 am
That's the way resource governor works... It doesn't limit if there's no need.
Only if there're other running jobs does it "cut" the user to 10%...
If that user is the only one running it uses 100%.
See this link, it explain how it works.
http://msdn.microsoft.com/en-us/library/bb934084.aspx
Pedro
October 23, 2009 at 11:17 am
Pimane is correct, this is not intended to limit all queries. It is designed to limit resources when there is contention.
If no one is on the server except a single user, why limit their resources?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply