Configuration Recommendations for Large Active Directory Environments

The major factor of evaluating the configuration requirements for SQL Server is the total number of effective users who can access the computers that are joined to zone in the Active Directory environment. You can estimate the total number of effective users by multiplying the number of computers joined to the zone by the average number of users who can access the computer.

Below lists the recommended configurations for SQL Server for some sample Active Directory environments.

Active Directory environment Sample #1:

Number of computers joined to a zone

1000

Average number of users who can access the computer

500

Total number of effective users

500 * 1000= 500,000

90% of user profiles and role assignments are explicitly defined at the zone level

Active Directory environment Sample #1 configuration recommendations :

SQL Server edition

SQL Server Express Edition with Advanced Services

SQL Server memory

8 GB

SQL Server disk space

30 GB

Active Directory environment Sample #2:

Number of computers joined to a zone

5,000

Average number of users who can access the computer

3,000

Total number of effective users

3,000 * 5,000 = 15,000,000

90% of user profiles and role assignments are explicitly defined at the zone level

Active Directory environment Sample #2 configuration recommendations :

SQL Server edition

SQL Server Standard Edition or above

SQL Server memory

64 GB

SQL Server disk space

80 GB