# Effective Max

• Comments posted to this topic are about the item Effective Max

• Simple maths, thanks!

Igor Micev,My blog: www.igormicev.com

• Easiest points yet, thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

• Easy one, thanks.

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

• Igor Micev (6/21/2014)

Simple maths, thanks!

Simple maths + basic misunderstanding = got it wrong :blush:

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
βCharles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

• Easy one thanks Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

• Thank you for the post, SJ, interesting one.

(at first... I was like "how am I suppose to pick the correct one?".. and the deep reading on RP in local_help for 10 minutes and 2hrs50mins of staring on the question ... I kind of summed like this.. "so min 50 for fin and 5 for everyone... and 50-5 = 45... okay 45 is in the choice... select it..." well I got it right on wrong calculation... π :-P)

...enjoyed it a lot.. (to be honest). I am going to remember this formula on RP.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

• If it's soooooo easy, why have less than half got it right?

• paul s-306273 (6/23/2014)

If it's soooooo easy, ...

yea it is... for each individual who said it, but they don't mean not in general to all. They were/are smart and one day we will be there too; hang in there, my friend.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

• Raghavendra Mudugal (6/23/2014)

paul s-306273 (6/23/2014)

If it's soooooo easy, ...

yea it is... for each individual who said it, but they don't mean not in general to all. They were/are smart and one day we will be there too; hang in there, my friend.

+1,lol π

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

• 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.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

• Nice question Steve, learnt something new today, so I had to do some R&D to got the right answer.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

• Nice question Steve! Had to do some research to get this one. The formula totally makes sense and is easy enough to actually memorize. π

• 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.

• nice question thanks steve..

Viewing 15 posts - 1 through 15 (of 17 total)