Microsoft Azure AD Connect - SQL Memory Usage?

Ward Horsfall 101 Reputation points


I am not sure of this - but I think Azure Sync / Synchronization Service Manager (miisclient.exe) is using lots of memory via SQL Server (sqlservr.exe)

  1. How much is the total RAM that should be required to run this process.
  2. How can I limit the RAM taken by this process?



Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,115 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Givary-MSFT 29,351 Reputation points Microsoft Employee

    @Ward Horsfall Thank you for reaching out to us. As I understand you are looking for inputs related to RAM for Azure AD Connect/SQL Server Memory.

    To begin with, you can refer to below table for CPU/Memory/Hard Drive minimum requirements for the Azure AD Connect sync server


    SQL database factors:

    The size of your source Active Directory topology will influence your SQL database performance. Follow the hardware requirements for the SQL server database and consider the following recommendations:

    Organizations with more than 100,000 users can reduce network latencies by colocating SQL database and the provisioning engine on the same server.
    Due to the high disk input and output (I/O) requirements of the sync process, use Solid State Drives (SSD) for the SQL database of the provisioning engine for optimal results, if not possible, consider RAID 0 or RAID 1 configurations.
    Don’t do a full sync preemptively; it causes unnecessary churn and slower response times.


    Let me know if you have further questions, please feel free to post back.