question

RONALDONASCIMENTO-1394 avatar image
0 Votes"
RONALDONASCIMENTO-1394 asked PRADEEPCHEEKATLA-MSFT edited

Azure Data Explorer database maximum size

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?

azure-data-explorer
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT edited

Hello @RONALDONASCIMENTO-1394,

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.

101316-image.png

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

101289-image.png

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.


image.png (11.4 KiB)
image.png (8.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.