Follow the SQL Server guidelines when choosing hardware for a MOSS 2007 Deployment

The following sections contain recommendations from the SQL Server 2005 team for hardware that can optimize performance of Office SharePoint Server 2007.

Memory

For the purposes of determining the amount of memory required for the computers running SQL Server 2005, first determine whether the planned deployment is small, medium, or large in terms of memory consumption.

Determine your deployment size by using the following table:

  • If your deployment parameters are generally less than the listed values, your deployment can be considered small.

  • If your deployment parameters are approximately equivalent to the listed values, your deployment can be considered medium.

  • If your deployment parameters are generally greater than the upper limits of most of the listed values, your deployment can be considered large.

Metric Value

Content database size

50 GB

Number of content databases

20

Number of concurrent requests to SQL Server 2005

200

Users

1000

Number of items in regularly accessed list

2000

Number of columns in regularly accessed list

20

For SQL Server 2005, 4 gigabytes (GB) is the minimum required memory, 8 GB is recommended for medium size deployments, and 16 GB and greater above is recommended for large deployments.

Other factors that can influence your memory needs include:

  • The use of SQL Server 2005 mirroring.

  • The frequent use of files larger than 15 megabytes (MB).

Para más información: https://technet.microsoft.com/en-us/library/cc298578.aspx, https://technet.microsoft.com/en-us/library/cc298801.aspx