Microsoft Azure AD Connect - SQL Memory Usage?

Ward Horsfall 101 Reputation points
2022-10-28T00:13:56.497+00:00

Hi,

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?

Thanks

Ward.

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
    2022-10-28T09:56:05.88+00:00

    @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

    255047-image.png

    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.

    Reference:
    https://learn.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-install-prerequisites#:~:text=Hardware%20requirements%20for%20Azure%20AD%20Connect
    https://learn.microsoft.com/en-us/azure/active-directory/hybrid/plan-connect-performance-factors

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