August 4, 2010 at 3:05 am
Hello,
I wondered if anyone here uses the 'Resource Governor'? I know it can get quite granular, but I was curious to know whether you can just allocate resources per instance overall, so basically if you have 2 instances on a machine, one had a database on it that get heavy usage, the other a database that has very light usage, can I just allocate more resource to one whole instance overall than the other? I actually have about 11 instances on a server thats 2005, but after move to 2008 I'm hoping to allow the resources to be used more economically in the right places to give better performance in others.
Thanks in advance for any advice and help.
Regards,
D.
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply