Log in  ::  Register  ::  Not logged in

 Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Effective Max Rate Topic Display Mode Topic Options
Author
 Message
 Posted Monday, June 23, 2014 6:12 AM
 SSCrazy Group: General Forum Members Last Login: Tuesday, October 25, 2016 7:23 AM Points: 2,456, Visits: 1,108
 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
 SSCrazy Group: General Forum Members Last Login: Tuesday, October 25, 2016 7:23 AM Points: 2,456, Visits: 1,108
 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
 SSCarpal Tunnel Group: General Forum Members Last Login: Friday, December 2, 2016 10:20 AM Points: 4,131, Visits: 2,324
 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 Group: General Forum Members Last Login: Monday, June 6, 2016 8:25 AM Points: 134, Visits: 94
 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
 SSCrazy Group: General Forum Members Last Login: Tuesday, March 8, 2016 10:23 AM Points: 2,144, Visits: 613
 nice question thanks steve..
Post #1585292
 Posted Tuesday, June 24, 2014 5:44 AM
 SSCrazy Eights Group: General Forum Members Last Login: Yesterday @ 4:17 PM Points: 9,934, Visits: 9,328
 Nice question. I learned something today, so thank you.
Post #1585468
 Posted Tuesday, June 24, 2014 8:31 AM
 SSCrazy Eights Group: General Forum Members Last Login: 2 days ago @ 6:34 AM Points: 9,823, Visits: 11,892
 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
 SSCrazy Group: General Forum Members Last Login: Tuesday, May 31, 2016 4:13 PM Points: 2,107, Visits: 2,254
 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

 Permissions

 Copyright © 2002-2016 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.