Can Resource Governor for SQL Server 2008 be scripted?
- by blueberryfields
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.
…