Resource Governer

Question

Resource Governer

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

CirquedeSQLeil (3/2/2011)
Koen Verbeeck (3/2/2011)
Great question, thanks.
I could deduce the correct answer since I ran the query on my development machine.
Not all results were zero and the columns aren't nullable, so there were two options left.
I have never had resource governer enabled, so I chose the 3rd option, which was the correct one.
It was only looking for the results of those two columns though - not all results. The default for those two columns is 0.

OK, I wasn't specific enough 🙂

The values for those two specific columns was 0 for 1 row and 1024-ish-something for a second row.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

UMG Developer SSChampion Points: 13482 More actions · Answer 2

Thanks for the question, it is nice to know that the RG gathers the stats even when it is disabled.

Steve Jones - SSC Editor SSC Guru Points: 738927 More actions · Answer 3

There is no implication in the question, at least not from what I read, that RG was enabled and disabled. It is "disabled" for non-internal groups by default, and doesn't work in Standard Edition.

In SE, it appears that only one row is returned, the internal group. In that case, I am not sure that it will return anything above zeros, but technically the feature isn't enabled at all.

In DE or EE, it is supposed to return and track the values, regardless of whether or not you have enabled RG for use by the admins to manage pools of connections and limit resources.