Azure Data Explorer database maximum size

MrSky 21 Reputation points
2021-05-28T03:24:17.01+00:00

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
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions
0 comments
Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 84,381 Reputation points Microsoft Employee
    2021-06-01T06:48:48.36+00:00

    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.

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest