Resource Governer

  • 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

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

  • 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.

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

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