Post reply

Resource Governer

  • March 1, 2011 at 11:42 pm

    #235937

    Comments posted to this topic are about the item Resource Governer

  • March 2, 2011 at 12:07 am

    #1293350

    Are we sure about that answer?

    http://msdn.microsoft.com/en-us/library/bb934013.aspx States:

    " Disabling Resource Governor has the following results:

    All existing workload group and resource pool settings are reset to their default values.

    "

    The default values for those counters is 0. I checked on several servers and all have Resource Governor disabled and all show 0's in those columns.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 2, 2011 at 12:08 am

    #1293352

    Here is the link that has the info on the default values for those fields.

    http://msdn.microsoft.com/en-us/library/bb934197.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 2, 2011 at 12:50 am

    #1293364

    Chose second option and found it to be wrong

    M&M

  • March 2, 2011 at 1:22 am

    #1293373

    CirquedeSQLeil (3/2/2011)

    Are we sure about that answer?

    http://msdn.microsoft.com/en-us/library/bb934013.aspx States:

    " Disabling Resource Governor has the following results:

    All existing workload group and resource pool settings are reset to their default values.

    "

    The default values for those counters is 0. I checked on several servers and all have Resource Governor disabled and all show 0's in those columns.

    Hi,

    the quote refers to settings, not statistics.

    I can confirm that with my R2 Install, the statistics are not reset when disabling resource governor.

    You can reset them with ALTER RESOURCE GOVERNOR RESET STATISTICS though.

    Best Regards,

    Chris Büttner

  • March 2, 2011 at 1:53 am

    #1293375

    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.

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

  • March 2, 2011 at 2:54 am

    #1293384

    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.

    exactly what I did 🙂

  • March 2, 2011 at 5:25 am

    #1293426

    grahamc (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.

    exactly what I did 🙂

    Exactly what I nearly did. Except I didn't know if it had been enabled or not, so chose the second option. Oops.

    Nice question though.

  • March 2, 2011 at 6:19 am

    This was removed by the editor as SPAM

  • March 2, 2011 at 8:16 am

    #1293538

    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.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 2, 2011 at 8:18 am

    #1293540

    Christian Buettner-167247 (3/2/2011)

    CirquedeSQLeil (3/2/2011)

    Are we sure about that answer?

    http://msdn.microsoft.com/en-us/library/bb934013.aspx States:

    " Disabling Resource Governor has the following results:

    All existing workload group and resource pool settings are reset to their default values.

    "

    The default values for those counters is 0. I checked on several servers and all have Resource Governor disabled and all show 0's in those columns.

    Hi,

    the quote refers to settings, not statistics.

    I can confirm that with my R2 Install, the statistics are not reset when disabling resource governor.

    You can reset them with ALTER RESOURCE GOVERNOR RESET STATISTICS though.

    Interesting because it doesn't say statistics it refers specifically to the view mentioned in this question as well.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 2, 2011 at 8:19 am

    #1293543

    CirquedeSQLeil (3/2/2011)

    Here is the link that has the info on the default values for those fields.

    http://msdn.microsoft.com/en-us/library/bb934197.aspx

    That was the link that led me to the right answer.

    It told me the two columns mentioned in the question values are not NULLABLE, and always show the value recorded by the system since the last reset.

    It also mentioned they are not configurable.

    I am certain this is why the two rows in this view have values on my QA 2008 R2 server becuase resource governor has always been disabled on this system.

    😎

  • March 2, 2011 at 8:23 am

    #1293548

    Thanks for the good question.

    It actualy made me read the documentation on this view and learn something about Resource Governer, how it works, and what the system runs for it disabled or not. :kiss:

    Worth 2 points any day.

  • March 2, 2011 at 8:25 am

    #1293550

    SanDroid (3/2/2011)

    CirquedeSQLeil (3/2/2011)

    Here is the link that has the info on the default values for those fields.

    http://msdn.microsoft.com/en-us/library/bb934197.aspx

    That was the link that led me to the right answer.

    It told me the two columns mentioned in the question values are not NULLABLE, and always show the value recorded by the system since the last reset.

    It also mentioned they are not configurable.

    I am certain this is why the two rows in this view have values on my QA 2008 R2 server becuase resource governor has always been disabled on this system.

    😎

    I read that bit too but considered that statement to be if the system had resource governor enabled. And since those fields default to 0, and resource governor being disabled resets those fields to their default values - I interpreted the question that to equate to Always 0. However, I am leery of any answer that has "Always" in it. I just don't think this question is as straight forward or unambiguous as some may think.

    What were the values in your columns (mentioned in the question)?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 2, 2011 at 8:55 am

    #1293563

    CirquedeSQLeil (3/2/2011)

    SanDroid (3/2/2011)

    CirquedeSQLeil (3/2/2011)

    Here is the link that has the info on the default values for those fields.

    http://msdn.microsoft.com/en-us/library/bb934197.aspx

    That was the link that led me to the right answer.

    It told me the two columns mentioned in the question values are not NULLABLE, and always show the value recorded by the system since the last reset.

    It also mentioned they are not configurable.

    I am certain this is why the two rows in this view have values on my QA 2008 R2 server becuase resource governor has always been disabled on this system.

    😎

    I read that bit too but considered that statement to be if the system had resource governor enabled. And since those fields default to 0, and resource governor being disabled resets those fields to their default values - I interpreted the question that to equate to Always 0. However, I am leery of any answer that has "Always" in it. I just don't think this question is as straight forward or unambiguous as some may think.

    What were the values in your columns (mentioned in the question)?

    I've got 0's for the internal group and 38036 and 90888 for the default group. I can enable and disable resource governer as much as I like and the values don't change.

    If I then run ALTER RESOURCE GOVERNOR RESET STATISTICS, the values return to 0.

Viewing 15 posts - 1 through 15 (of 18 total)

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