Microsoft SQL Server

Microsoft® SQL Server requires a computer with at least 16 MB of RAM. If the server will be configured to participate in data replication as either a distribution or a combined publication/distribution server, it must have at least 32 MB of memory, with at least 16 MB available to SQL Server.

Note  The preceding system requirements are only for SQL Server and do not represent requirements for other BackOffice components that are frequently integrated with SQL Server, such as Microsoft Systems Management Server or Internet Information Server.

SQL Server requires a minimum of 60 MB of available hard disk space. Additional memory and disk space may be required, depending on how SQL Server is deployed. The following formula will help you calculate the additional recommended disk space:

additional_space=1.2(dataset)

The size of the additional disk space required is approximately 120 percent of the estimated size of the dataset.

The following formula will help you estimate the additional recommended system memory:

additional_memory=1.08(dataset)+1.04(users)

In this formula, additional_memory is the amount of memory recommended in addition to the minimum of 16 MB. The variable dataset is the estimated size of the dataset, and users is the number of users accessing the server. In other words, the amount of additional memory recommended is 8 percent more than the estimated dataset size, plus 1 MB for every 25 users accessing the server.

Note  The preceding system requirements are based on the assumption that Microsoft SQL Server is installed and running on top of Windows NT Server. These requirements incorporate general Windows NT Server requirements but may vary depending on your specific system environment.