Azure Data Explorer database maximum size

Question

I have a total of 50 log analytics workspaces. One log analytics workspace is 80TB in size. Other workspaces are below 5TB.
I am designing Azure Data Explorer as long-term retention storage.

I understand I should plan one or few ADX clusters to serve multiple log analytics workspaces.

Question:

1. How many total databases can I house under a single ADX cluster?
2. What is the maximum combined size of databases I should plan to house a single ADX cluster?
3. Any performance constraints if add all 50 databases under one single cluster?

Answer 1

Hello @MrSky ,

Welcome to the Microsoft Q&A platform.

1) How many total databases can I house under a single ADX cluster?

Number of databases in a cluster – 10000

2) What is the maximum combined size of databases I should plan to house a single ADX cluster?

There is no limit on maximum combined size of databases.

3) Any performance constraints if add all 50 databases under one single cluster?

There are no performance constraints.

The following table describes the maximum limits for Azure Data Explorer clusters.

The following table describes the limits on management operations performed on Azure Data Explorer clusters.

Hope this helps. Do let us know if you any further queries.

---

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.