Wednesday, August 1, 2012

Estimate RAM/memory requirements SQL server- SharePoint 2010

The memory required for SharePoint Server 2010 is directly related to the size of the content databases that you are hosting on a server that is running SQL Server.
As you add service applications and features, your requirements are likely to increase. The following table gives guidelines for the amount of memory we recommend.
Combined size of content databases
RAM recommended for
computer running SQL Server
Minimum for small production deployments8 GB
Minimum for medium production deployments16 GB
Recommendation for up to 2 terabytes32 GB
Recommendation for the range of 2 terabytes to 5 terabytes64 GB
Recommendation for more than 5 terabytes
Additional RAM over 64 GB can improve
SQL Server caching speed

note Note:
These values are higher than those recommended as the minimum values for SQL Server because of the distribution of data required for a SharePoint Server 2010 environment. For more information about SQL Server system requirements, see Hardware and Software Requirements for Installing SQL Server 2008 (http://go.microsoft.com/fwlink/p/?LinkId=129377).
Other factors that may influence the memory required include the following:
  • The use of SQL Server mirroring.
  • The frequent use of files larger than 15 megabytes (MB).

1 comment:

  1. User load and the type of transactions really matter. You need to really research to find what is needed. We have 1.5TB of data for 30,000 users on 1,200 sites plus we are running mySites. Your recommendations would bring the platform to a crawl.

    ReplyDelete