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

Effective Max Expand / Collapse
Author
Message
Posted Monday, June 23, 2014 6:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:46 AM
Points: 1,257, Visits: 597
paul s-306273 (6/23/2014)
If it's soooooo easy, why have less than half got it right?

Maybe because whoever got it wrong are not familiar with the Resource Governor basics.
Post #1585080
Posted Monday, June 23, 2014 7:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:46 AM
Points: 1,257, Visits: 597
Nice question Steve, learnt something new today, so I had to do some R&D to got the right answer.
Post #1585110
Posted Monday, June 23, 2014 10: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: 2 days ago @ 10:57 AM
Points: 3,323, Visits: 1,988
Nice question Steve! Had to do some research to get this one. The formula totally makes sense and is easy enough to actually memorize.
Post #1585192
Posted Monday, June 23, 2014 2:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:09 AM
Points: 115, Visits: 90
Perhaps we got it wrong for exactly the same reason that using such minimum settings is a bad idea in many cases. SQL Server will hold the sum total of MIN setting idle if those pools with the MIN setting aren't being utilized. Therefore, if you have ten pools (pool1 through pool10) that HAVE 10% MIN and 100% MAX, and all pools are sitting idle until pool4 gets a big load, 90% of your resources will remain idle while pool4 struggles to handle the load with only 10% of the available resources.

Yes, the example is extreme, but so is the waste made possible by (mis-?)using this feature. The rationale is that a long query could tie up the resources for a while if allowed to utilize another pool's MIN amount, so it must sit idle when that pool isn't using it.
Post #1585277
Posted Monday, June 23, 2014 2:12 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 11:49 AM
Points: 1,848, Visits: 587
nice question thanks steve..
Post #1585292
Posted Tuesday, June 24, 2014 5:44 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 @ 2:52 PM
Points: 3,971, Visits: 3,406
Nice question. I learned something today, so thank you.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1585468
Posted Tuesday, June 24, 2014 8:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:24 PM
Points: 7,688, Visits: 9,410
paul s-306273 (6/23/2014)
If it's soooooo easy, why have less than half got it right?

It's only easy for people who have some idea how resource pools work. Most people make no use of resource pools, and a lot of those who don't use them (and some of those who do) don't bother to learn about them.


Tom
Post #1585538
Posted Tuesday, June 24, 2014 2:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:35 AM
Points: 1,825, Visits: 2,175
Easiest three points ever. That much closer to using my points stash for retirement.

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1585683
Posted Tuesday, June 24, 2014 3:00 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:39 AM
Points: 2,935, Visits: 239
Thanks for the question.
Post #1585688
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse