January 2, 2015 at 4:02 am
I have a server running SQL Server 2008 R2 Standard (10.50.2500, yes I know it needs patching), with a single named instance running on the server.
When I query sys.dm_resource_governor_resoucre_pools, there is only a single row returned, for the internal pool. I thought even on standard edition that the default pool was always present?
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
January 2, 2015 at 8:35 am
It should be. Perhaps something is broken here, but there should always be two pools on all instances.
January 3, 2015 at 12:30 am
OK thanks for the reply. Any ideas on what to look at to troubleshoot? Would trying to run the disable resource governor alter statement reset it all, or would that not work as its standard edition?
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
January 3, 2015 at 11:13 am
No idea here, but I spoke too soon. I could have sworn I'd seen a Standard Edition demo showing two pools, but perhaps not.
When I check the SSC server, 2008 Std, we only see the internal pool. Perhaps the standard edition code hides the default?
No idea, but it hasn't cause us any issues in 6-7 years, so perhaps it doesn't matter.
January 3, 2015 at 2:15 pm
Ah OK. Well, I only really started looking into it after porting some code that was using the performance counters for the pools from an enterprise edition, which was doing some monitoring using the CPU counters for the pools; got some odd looking results with only the internal counter present so got curious as to why it wasn't there. Looks like it may not be a problem.
Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply