Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Resource Governer Expand / Collapse
Author
Message
Posted Tuesday, March 1, 2011 11:42 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 6:20 PM
Points: 33,078, Visits: 15,192
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
Post #1071734
Posted Wednesday, March 2, 2011 12:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:13 PM
Points: 21,229, Visits: 14,937
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1071745
Posted Wednesday, March 2, 2011 12:08 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:13 PM
Points: 21,229, Visits: 14,937
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1071747
Posted Wednesday, March 2, 2011 12:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:56 PM
Points: 2,270, Visits: 3,781
Chose second option and found it to be wrong

Mohammed Moinudheen
Post #1071761
Posted Wednesday, March 2, 2011 1:22 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 1:45 AM
Points: 2,826, Visits: 3,866
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
Post #1071773
Posted Wednesday, March 2, 2011 1:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 13,283, Visits: 10,156
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1071777
Posted Wednesday, March 2, 2011 2:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:45 AM
Points: 563, Visits: 1,000
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 :)
Post #1071788
Posted Wednesday, March 2, 2011 5:25 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
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.
Post #1071841
Posted Wednesday, March 2, 2011 6:19 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 3,859, Visits: 5,001
Thanks for the question


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1071865
Posted Wednesday, March 2, 2011 8:16 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:13 PM
Points: 21,229, Visits: 14,937
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1071964
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse