August 4, 2010 at 9:16 am
Don't think you can do instance management. One thing to watch out for is memory usage, Resource governor doesn't manage memory so if you have two instances and you want one to be the faster one you may want to set hard memory limits for both instances so the 'prime' instance does not get memory starved.
August 4, 2010 at 9:37 am
Henry is correct
per--Microsoft
Resource Governor Constraints
This release of Resource Governor has the following constraints:
Resource management is limited to the SQL Server Database Engine. Resource Governor can not be used for Analysis Services, Integration Services, and Reporting Services.
There is no workload monitoring or workload management between SQL Server instances.
Limit specification applies to CPU bandwidth and memory managed by SQL Server.
OLTP workloads. Resource Governor can manage OLTP workloads but these types of queries, which are typically very short in duration, are not always on the CPU long enough to apply bandwidth controls. This may skew in the statistics returned for CPU usage %.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply