Can Resource Governor for SQL Server 2008 be scripted?
Posted
by blueberryfields
on Server Fault
See other posts from Server Fault
or by blueberryfields
Published on 2010-01-05T02:50:42Z
Indexed on
2010/03/15
14:00 UTC
Read the original article
Hit count: 421
sql-server-2008
|resource-management
I'm looking for a method to, in real-time, automatically, adjust Resource Governor settings.
Here's an example:
Imagine that I have 10 applications, each hitting a different database on the same database machine. For normal operations, they do not hit the database very hard, so I might want each one to have 10% CPU power reserved.
Occasionally, though, one or two of them might spike, and run an operation which could really use the extra power to run faster. I'd like to be able to adjust to compensate (say, reducing the non-spiking apps to 3%, and splitting the difference between the spiking apps).
This is a kind of poor man's method of trying to dynamically adjust resource allocation and priorities.
Scripts (or something script-like) is preferred, since the requirement is for meta-level adjustments to be possible in real-time, also.
© Server Fault or respective owner