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 pools Expand / Collapse
Author
Message
Posted Monday, June 9, 2014 10:57 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item Resource Governor pools






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1579033
Posted Tuesday, June 10, 2014 12:13 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:28 PM
Points: 13,263, Visits: 11,053
Easy one, 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 #1579044
Posted Tuesday, June 10, 2014 12:18 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Koen Verbeeck (6/10/2014)
Easy one, thanks!

+1


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1579048
Posted Tuesday, June 10, 2014 12:24 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: Monday, October 6, 2014 6:14 AM
Points: 564, Visits: 888
Thanks for question Steve.
Learnt new thing today.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1579051
Posted Tuesday, June 10, 2014 5:41 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 4,231, Visits: 3,665
I learned something new today, so thanks for the question.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1579130
Posted Tuesday, June 10, 2014 6:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 5:49 AM
Points: 2,521, Visits: 1,367
Question should have been "In SQL Server 2014, which of these is not a valid resource pool argument?".
Post #1579135
Posted Tuesday, June 10, 2014 6:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:59 PM
Points: 4,019, Visits: 5,316
Nice one, Steve, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1579158
Posted Tuesday, June 10, 2014 7:07 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:17 PM
Points: 17,815, Visits: 15,744
William Vach (6/10/2014)
Question should have been "In SQL Server 2014, which of these is not a valid resource pool argument?".


I'd probably go with setting. But the question is fine as is.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1579169
Posted Tuesday, June 10, 2014 8:08 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:16 AM
Points: 2,107, Visits: 2,114
SQLRNNR (6/10/2014)
William Vach (6/10/2014)
Question should have been "In SQL Server 2014, which of these is not a valid resource pool argument?".


I'd probably go with setting. But the question is fine as is.


According to the documentation, they are arguments that get values assigned to them. Maybe a setting could also be referred to as a value but not the argument itself.

Didn't mean to split hairs, I just wanted to say something other than the standard "easy, thanks, ...".

And totally agree, the question is fine as.

Thanks Steve!
Post #1579224
Posted Tuesday, June 10, 2014 9:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Sunday, October 19, 2014 11:12 AM
Points: 7,791, Visits: 9,545
Dave62 (6/10/2014)
SQLRNNR (6/10/2014)
William Vach (6/10/2014)
Question should have been "In SQL Server 2014, which of these is not a valid resource pool argument?".


I'd probably go with setting. But the question is fine as is.


According to the documentation, they are arguments that get values assigned to them. Maybe a setting could also be referred to as a value but not the argument itself.

Didn't mean to split hairs, I just wanted to say something other than the standard "easy, thanks, ...".

And totally agree, the question is fine as.

Thanks Steve!

Well, I disagree with you and Jason. As the question is worded, it is obvious what the author thinks the answer is, but that doesn't make it a fine question, because when i create a resource pool I can call it pretty much what I like so all these could be valid resource polls, but none of these is either of teh built-in resource pools that come with reource governor so both "all of these" and "none of these" would be at least as correct as the "correct" answer and would actually answer the question that was actually asked (which is ambiguous anyway, hence two contradictory possible answers) rather than what Steve presumably intended to ask, which was what of teh listed things was not the name of a valid pool resource setting.
Not a catastrophic error in the question, but if you've ever been involved in reviewing requirements statements to ensure that what development or production (as the case may be) understands them to mean is the same as what the people who raised the requirements intended the statement to mean you will know that this sort of misuse of terms is just not acceptable - or if you don't know that, I hope that you will enjoy trying to explain why a misunderstanding was allowed to go undetected when, at teh end of the day, the user acceptance trial rejects the thing because it works as development and QA thought it should but they thought wrong, as the inevitable result of not eliminating scope for misunderstanding at the start is discovering misunderstanding at the end.


Tom
Post #1579259
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse