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 Governor Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 11:32 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 6:10 PM
Points: 32,099, Visits: 16,521
Comments posted to this topic are about the item Resource Governor






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1439099
Posted Thursday, April 4, 2013 11:39 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
I just guess and got correct 2 out of 3.




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1439101
Posted Friday, April 5, 2013 12:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:36 AM
Points: 14,438, Visits: 12,425
Nice question, thanks!



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 #1439113
Posted Friday, April 5, 2013 4:26 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, September 1, 2014 7:39 AM
Points: 642, Visits: 520
Not using 2012 yet so 2 out of 3 ain't bad. Good to know though for when we do upgrade.


MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk
Post #1439150
Posted Friday, April 5, 2013 5:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Sunday, January 4, 2015 7:55 AM
Points: 5,333, Visits: 25,280
Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1439167
Posted Friday, April 5, 2013 7:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, June 24, 2015 3:16 PM
Points: 2,153, Visits: 1,601
bitbucket-25253 (4/5/2013)
Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?


+ 1




Everything is awesome!
Post #1439202
Posted Friday, April 5, 2013 10:54 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: Friday, June 12, 2015 1:08 PM
Points: 3,688, Visits: 72,447
bitbucket-25253 (4/5/2013)
Knew two - guessed the 3rd .... but wondering how many of those answering the question actually use the Resource Governor ?



I do I do! Not on 2012 (yet), but we have some people who have rights to run queries against our production server. They go into a resource governor pool that keeps them from swallowing all of the resources on the server with their
"I know SQL" queries.





--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1439369
Posted Friday, April 5, 2013 12:18 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, February 11, 2015 1:54 PM
Points: 1,922, Visits: 1,396
Even though the question said "the three options", I went and picked only two. I've never used the resource governor, so I wouldn't have gotten it right anyway. =P

This made me wonder: what does the minimum CPU setting mean? If there aren't enough queries on that resource pool to reach the minimum, the server will dedicate its resources to that anyway?
Post #1439410
Posted Friday, April 5, 2013 9:35 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:27 PM
Points: 18,747, Visits: 16,994
Thanks for 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
Post #1439544
Posted Thursday, April 25, 2013 1:43 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: Monday, May 25, 2015 4:21 AM
Points: 3,595, Visits: 2,702
Good easy question.
Post #1446328
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse