Hi!

Im currently trying to design a 2 DAGs solution for a customer with 4 copies, on 2 datacenters.

I would like to apply best practices here and use 4 databases on each JBOD disks.

However, Im unable to set the sizer to get a 4 db/volume configuration if I use the Active/Active (Multiple DAG) setting.

Only way to get this result is to increase the number of servers.

However, this is OK if I use the Active/Active (single DAG) option.

Am I wrong somewhere ?

Thanks for your help! Have a great day !

Hi Jmo91,

This need to be clearer before we can comment.

Let me know if I have got this right.

DatacentreA: MBX-A1,MBX-A2,MBX-A3,MBX-A4,CAS-A1,CAS-A2,CAS-A3

DatacentreB: MBX-B1,MBX-B2,MBX-B3,MBX-B4,CAS-B1,CAS-B2,CAS-B3

DAG-1: MBX-A1,MBX-A2,MBX-B3,MBX-B4

DAG-2: MBX-B1,MBX-B2,MBX-A3,MBX-A4

Witness for DAG-1: CAS-A1; AltWitness: CAS-B2

Witness for DAG-2: CAS-B1; AltWitness: CAS-A2

NOTE:- Incase you don't have separate CAS boxes, consider any other File Share server.

So each DAG-x will host 1 active copy, with 3 passive copies for each database. (Let's say you want 4 DBs in total to make it simple 1 Volume scenario, but you can have more ofcourse)

Hence Total DBs:

DAG1: (1+3)*4=16 DBs (4Active+12Passive)

DAG2: (1+3)*4=16 DBs (4Active+12Passive)

As you are going for 2 DC setup, in normal operations

DC-A will have 4 active copies of DAG1

DC-B will have 4 active copies of DAG2

or Each DC-x will have 2 active copies from each DAGx - a total of again 4 active copies.

As you said you need 4DBs per volume that would mean you need atleast 1 volumes dedicated for DBs per server. [(2Act+2pas) or (4 pass) or (1Act+2pass)]

Few important consideration factors missing are the no. of users. I have hence considered it to be something which 4 DBs can hold 100*4=400 users maybe.

We are also considering you have 4TB large volumes.

One thing we can't do on the Calc is tell that I want a lagged copy of DAG2 on DC-A, by setting it considers DC-B as secondary and hence puts the lagged copy there, we might change the design as per our requirements.

I'm considering both sites are primary to some set of users and other site is secondary for them. That's being the reason for positioning the witness earlier. The Calc doesn't seem to have option to do this when I have only 4copies.

It keeps atleast 2 non-lagged DB copies on the Primary side.

Below is what I get.

Hi,

Tried something else as well.

Increased the users to 100000, this increased the mailboxes per DB to 500/DB
and Total DBs to 200 (100/DAG) 

Hence =500users*200DBs= 1lakh mailboxes

Below remains same:
Suggested Number of Databases / Volume 4
Number of Databases / Volume   4

Criteria used for the 'suggested no. of Database' is as below:
This is the largest number of the following three inputs:
 - Number of copies in the DAG - 4 in our case
 - Maximum number of databases that will fit on the selected disk configuration - we get warning here as 4TB disks we considered are not enough
 - Maximum supported databases per volume - Aaa! Guess its 4.

Keep an eye for warnings, as the one I have below (after increasing the users to 1lakh, but not the disk or servers)

WARNING[YELLOW]: One or more disk capacities you have selected for this design is insufficient for deploying a JBOD solution.

DB and Log Volume Design / Server:

Database Copy: DB1-DB4
DB+Log Volume Size Required: 28786 GB

After all this the 'Possible Storage Architecture remains JBOD' for total of 8servers with 2 DAGs across 2 data centres. Ofcourse you need to add more servers or larger volume for this to work get the warning out.

Hello Satyajit,

Thank you for your answer.

My question was about an active/active (MULTIPLE DAG) configuration.

I already know that in an active/active (single dag), I can have 4 databases on a single disk :)

Hi Jmo91,

My bad, I'll re-test this and get back to you.

Hi Jmo91,

Here is how it worked for me:

In my previous example I had 2 Servers X 2 Sites X 2 No. of DAGs = 8 servers.

Site Resilience User Distribution Model: Active/Active (Single DAG)

Now to change is same configuration to Active/Active (Multiple DAGs) model

We will notice that the Exchange Environment Configuration Section in the INPUT sheet

No. of Database Availability Groups has changed to something else:

Database Availability Group Multiplier:

Enter the number of database availability groups you will deploy in your environment.

If you are deploying an Active/Active (Multiple DAGs) site resilient architecture then by default you have a minimum of 2 DAGs being deployed.  If your design requires additional DAGs utilize this field by entering in the multiple you require.

For example if you are planning to have 2 DAGs active in Datacenter 1 and 2 DAGs active in Datacenter 2 (with passives in the opposing datacenter), you would enter 2 in this field.

Basically to match our previous example we have to make changes:

2 Servers X 2 Sites X 1 DAG Multiplier = 8 servers.

NOTE:- As the Multi model automatically multiples it by 2 to match the configuration.

Even when we tried best to keep the configuration match the Active/Active (Single DAG) model, the Volume design changes from 4DB/Vol to 2DBs/Vol. Irrespective of the fact that we actually have the exact same hardware, server and user count.

Volume Requirements (Sheet)

There is a catch which I found while backtracking the formulas and comments for this value. Multiple DAG user distribution model is nothing but, Active/Passive Model but with multiple Active sites using multiple DAGs.

As per individual DAG perspective this is no different than an Active/Passive model. This can be observed in Distribution Sheet which represents a single DAG view and failover scenario.

Once we have established that its a A/P model, looking at the comments for the below field, we can see that #DB/Volume = #DB copies/site

INPUT (Sheet)-Storage Options- Number of Databases / Volume Matches Total Database Copy Count

By default, the number of copies that will be deployed on a volume will match the total number of copies available per database (per site in A/P scenarios).  For example, if you design an A/A solution that has two copies in the primary datacenter and two copies in the secondary, then when deploying multiple databases per volume, you will have four copies per volume.

If you want to deploy less copies per volume, select No. In this scenario, the calculator will use half the total number of copies/disk.

This explains why we have the 2DB/Volume. Lets look at the configuration once more:

2 Servers X 2 Sites X 1 DAG Multiplier = 8 servers.

Per site: 2 Servers X 1 Sites X 2 = 4 servers (NOTE this is for 2DAGs)

Per site per DAG: 2 servers

Hence for individual DBs;  we have only 2 servers = only 2 database copies available per site per DAG. This resulted in 2DB/Volume.

Lets fix this:

I have increased the no. of server per site to 4 and other options are highlighted.

4 Servers X 2 Sites X 1 DAG Multiplier = 16 servers. (8 servers per DAG)

As you can see that the Number of Databases / Volume now shows as 4 DBs.

Few insights from the formulas in Role Requirements sheets  C81,C82 cell:

Things considered for individual DAGs

Single DAG model: MIN ((Max Disk size/max. DB size calculated) , (No. DB copies in Primary site + No. DB copies in 2^nd Site))

Active Passive or Multi DAGs model:  MAX(No. DB copies in Primary site ,  No. DB copies in 2^nd Site)

Conclusion:

Changes to high availability and site resilience over previous versions \ Multiple databases per volume

The key is that the number of copies of each database that you have should be equal to the number of database copies per disk. However its not mentioned in TechNet that this is limited to per site or

Hi,

We have always been able to store multiple databases on a RAID array, but storing multiple databases on a JBOD spindle was previously not supported.

Basically the JBOD Multiple databases per Volume is supported based on the below facts:

1. Disks hosting passive database copies and Lagged copies are underutilized in terms of IOPS.
2. The goal is to drive the distribution of users across the number of volumes that exist during normal operations.
3. Storage disk size are increasing 8TB, but recommended DB size are not beyond 2TB (IOPS are still same). This would lead to un-utilized space per volume.

Keeping all this in mind, under normal operations we can have 1 Active DB copy + x Passive copies + y Lagged copies.

In our initial scenario, when we are in Active/Active (Multi DAG) Model. All the active DBs need to be in the primary site, but we have only 2 servers per site to distribute them. Every alternate DB will be Active on each server.

Hence if we use 4DB per Volume, it would lead to 2 Active DBs per Volume, which is not a desirable condition under normal operations. Solution is 2DB per Volume and have more no. of volumes.

This being the reason E2013Calc is suggesting 2DBs per Volume with 2 Servers on one

Hello Satyajit.

This is a very clear and complete answer to my original question.

Have a nice day !

Hi Jmo91,

Thank you.