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: Yesterday @ 3:05 PM
Points: 31,284, Visits: 15,750
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 17,977, Visits: 15,981
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
Post #1071745
Posted Wednesday, March 2, 2011 12:08 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 17,977, Visits: 15,981
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
Post #1071747
Posted Wednesday, March 2, 2011 12:50 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
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, October 7, 2014 2:56 AM
Points: 2,842, Visits: 3,876
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 @ 3:04 AM
Points: 13,566, Visits: 11,376
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: Tuesday, October 28, 2014 4:32 AM
Points: 562, Visits: 1,036
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: Tuesday, October 21, 2014 6:56 AM
Points: 3,352, Visits: 1,487
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 4,120, Visits: 5,486
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 17,977, Visits: 15,981
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
Post #1071964
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse