• Jayanth_Kurup (3/12/2012)


    Would 4 GB on OS RAM be sufficent for a database being used with sharepoint ?

    Depends on what else is installed on the server and how much memory there is in total. If there's nothing other than SQL Server on that machine and there's 32 GB physical memory then 4GB is certainly adequate and probably generous. If the sharepoint frontend is on the same server (so IIS and the web application) then the SQL max memory needs to be lowered to allow the 4GB for the OS and whatever IIS needs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass