Resource Governer

Question

Resource Governer

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

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Duncan Pryde (3/2/2011)
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.

Thanks. That helps alot. I only get one recordset - just the internal group. Excellent learning topic. Thanks all.

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

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 3

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: 736211 More actions · Answer 4

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.