Effective Max

Question

Post reply

Effective Max

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
June 21, 2014 at 5:07 pm

#74769

Comments posted to this topic are about the item Effective Max

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

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

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 1

Simple maths, thanks!

Igor Micev,My blog: www.igormicev.com

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 2

Easiest points yet, thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

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

Easy one, thanks.

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

Neil Burton SSC-Insane Points: 22999 More actions · Answer 4

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 5

Easy one thanks Steve.

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

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.

paul s-306273 SSChampion Points: 10730 More actions · Answer 7

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

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.

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

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

Ken SSCoach Points: 17191 More actions · Answer 12

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

dinolg SSC Enthusiast Points: 146 More actions · Answer 13

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.

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 14

PChiragS

SSCarpal Tunnel

Points: 4965

June 23, 2014 at 2:12 pm

#1724193

nice question thanks steve..