SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Resource Governer


Resource Governer

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (283K reputation)SSC Guru (283K reputation)SSC Guru (283K reputation)SSC Guru (283K reputation)SSC Guru (283K reputation)SSC Guru (283K reputation)SSC Guru (283K reputation)SSC Guru (283K reputation)

Group: Administrators
Points: 283893 Visits: 19914
Comments posted to this topic are about the item Resource Governer

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)

Group: General Forum Members
Points: 125194 Visits: 18627
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

SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)

Group: General Forum Members
Points: 125194 Visits: 18627
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

M&M
M&M
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10850 Visits: 3918
Chose second option and found it to be wrong

M&M
Christian Buettner-167247
Christian Buettner-167247
SSCertifiable
SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)SSCertifiable (7.7K reputation)

Group: General Forum Members
Points: 7677 Visits: 3889
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
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)

Group: General Forum Members
Points: 125555 Visits: 13344
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.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
grahamc
grahamc
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2952 Visits: 1039
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 Smile
Duncan Pryde
Duncan Pryde
SSCertifiable
SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)SSCertifiable (5.1K reputation)

Group: General Forum Members
Points: 5122 Visits: 1552
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 Smile


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.
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSC-Dedicated
SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)

Group: General Forum Members
Points: 31012 Visits: 7619
Thanks for the question

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)SSC Guru (125K reputation)

Group: General Forum Members
Points: 125194 Visits: 18627
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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search