Is there a formula for connection pool size?

I develop webservices with event driven architecture and I was wondering if there is a formula to count the optimal connection pool size? Even if there isn’t it would be a big help to know what it depends on or see real life measurements to know at least the order of magnitude. I tried to find scientific articles in the topic without success, but maybe I used the wrong keywords.

AnyDice: Sum of dice pool + highest value from the same roll

I want to calculate the sum of a mixed dice pool, but add the nth highest value of that pool twice.

For example the code

output 2d4+1@2d4 

Gives the sum of 2d4 and the highest value of a separately rolled 2d4. Instead I’d like to add the highest value of the same 2d4.

This does produce different results; in the example above the probability of rolling a total of 3 is 0.39%, while in the situation I’m after the probability should be 6.25%.

Ideally the solution should be able to handle rolling mixed die pools such as 2d10+1d8+1d6+the second highest value rolled, but I would still find solutions that cannot do so useful.

AnyDice: Second highest roll from mixed pool

I’m struggling to adapt Ilmari Karonen’s answers from these two questions to my problem.

I want to look at the second highest value from various pools.

function: max A:n B:n C:n {     result: 2@[sort {A, B, C}] } output [max 1d12 1d10 1d8] 

Produces possibly believable results, but:

output [max 2d12 0d10 0d8] 

Is not at all believable, and completely disagrees with:

output 2@2d12 

Similarly testing with

function: maxs A:n {     result: 2@[sort {A}] } output [maxs 2d12] 

hasn’t helped.

In AnyDice, how can I calculate the number of successes in the highest dice in a given dice pool?

I’ve tried the following code

output [count {5..6} in [highest 2 of 10d6]] 

Which yields

0: 99.90% 1:  0.10% 

However, these results are implausible. In a 10d6 pool the chances of there being at least one 6 or 5 should be extremely high, and two of them should at least be expected once in a while.


I now understand that AnyDice is trying to find 5s and 6s in the sum of the top two dice of the pool, which is not what I want. I’m still no closer to finding out how to get what I’m looking for.

Residential Proxies – Autoraotate every 5th minute – 30M+ IPs pool all over the world.

Hello Friends,
Are you looking for the best anonymous residential rotating backconnect proxy service, check out https://proxyvoxy.com
– More than 30 Million IPs pool
– Superfast residential proxy
– No Bandwidth Limitations
– Very reasonable Pricing
– Proxy Rotates every 5th minute
– IPs available in all the countries
– 99.9% uptime guaranteed
– 3 Days money-back guarantee
– Fast support
P.S. Get flat 50% discount on Special Backconnect proxies if you order above 
2000 Ports. Contact on skype: bmsoftwares to get the discount.

Azure elastic pool: Can I create as many databases as I want?

I am sitting here trying to figure out what the elastic pool in Auzre gives me. I have a customer that wants a guess on pricing if the move to Azure. They have 3 databases, on a server. The server has 96 GBs of RAM and a 3.4 Ghz processor. That is all i know. The three databases is sharing these specs, and each database has it own area of expertise:

  1. one database handles all the CMS data
  2. the second database handles all the commerce data
  3. the third database is a database that stores user info, etc – all data that doesnt fit the two others

I think the usage pattern is pretty diverse, so sometimes the commerce is using a lot of RAM and CPU, other times it is the CMS etc.

I dont think they fit well into a single database, because they are going to need three big databases then, and almost all of them is going to be under utilized all the time. So I thought about elastic pools.

The describtion of ealstic pools fits the above very well: all databases shares eDTUs. Perfect! But one thing the docs doesnt describe is: do i pay for the elastic pool AND pr database? Or do I just create databases on the fly, and all of them shares, that is: the databases is free, but you pay for the eDTU.

I have read this https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool – but they don’t describe it.

Hope someone can give me some more info.