Resource Governor defaults

Question

Resource Governor defaults

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
January 13, 2011 at 9:54 pm

#63770

Comments posted to this topic are about the item Resource Governor defaults

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Nice and easy question. Thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

DugyC Hall of Fame Points: 3804 More actions · Answer 2

Took a while over this as was debating with myself wether "user defined" pools, which are also available with Resource Governor, counted as "Guest" pools. In the end I decided not to count that.

Fortunately 😉

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

OCTom SSChampion Points: 11785 More actions · Answer 3

DugyC (1/14/2011)
Took a while over this as was debating with myself wether "user defined" pools, which are also available with Resource Governor, counted as "Guest" pools. In the end I decided not to count that.
Fortunately 😉

I was thinking the same thing but chose not overthink the QotD today.

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

I also included System, which of course isn't actually a pool it is a type of pool. /sigh

Great question, had to brush on the topic since this is not the sort of thing I look at all that frequently.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

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[/url]
Learn Extended Events

UMG Developer SSChampion Points: 13482 More actions · Answer 6

UMG Developer

SSChampion

Points: 13482

January 21, 2011 at 3:39 pm

#1276840

Thanks!

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 7

Hardy21

SSCrazy Eights

Points: 9708

February 7, 2011 at 4:39 am

#1283027

Thanks for the question.. 🙂

Thanks