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