Once SQL Server has cached the entire SharePoint database, plus some more for tempDB, there isn't much point throwing any more RAM at SQL Server. IIS will also do some caching - your w3wp.exe processes to get large as well.
To OP: have a think about how big your databases are likely to be. If you have 1GB of content, then 16GB of RAM is more than enough. Cheers Ken From: Kevin Lundy [mailto:[email protected]] Sent: Wednesday, 14 September 2011 8:49 PM To: NT System Admin Issues Subject: Re: Query re Virtual CPUs IMO putting the SQL on the same server is what pushes the memory up. Yep, isn't virtualization great for maximizing hardware. To the OP, I would start with 16 as a test, but be prepared to increase the memory to 32. Or maybe consider 2 guests. 1 for SQL and 1 for SharePoint. Kevin On Wed, Sep 14, 2011 at 8:42 AM, Richard Stovall <[email protected]<mailto:[email protected]>> wrote: Interesting. At $Work we're running Sharepoint 2010 Foundation for ~10 users on an ESX 4.1 VM with 2GB RAM and 1 vCPU, and it's plenty fast. The database is located on another server. With only one calendar and a couple of document libraries, I'll be the first to admit that we don't push it hard at all. Nevertheless, it's quite zippy. I think there are lots of variables in play. The good news is that the OP can allocate and de-allocate RAM and vCPUs to find what's really necessary for his environment. On Wed, Sep 14, 2011 at 8:13 AM, Kevin Lundy <[email protected]<mailto:[email protected]>> wrote: On this rare circumstance, I am going to disagree with ASB. While tech editing a book, I ran this exact scenario. With the SQL and SharePoint on the same virtual guest allocated 16G, I was not happy with performance and I was the only user. I would suggest 32G. On Wed, Sep 14, 2011 at 7:19 AM, Andrew S. Baker <[email protected]<mailto:[email protected]>> wrote: Agreed. With ~25 active users, and even a shared SQL instance, that server would be fine with 4-6GB RAM ASB http://XeeMe.com/AndrewBaker<http://xeeme.com/AndrewBaker> Harnessing the Advantages of Technology for the SMB market... On Wed, Sep 14, 2011 at 7:11 AM, John Cook <[email protected]<mailto:[email protected]>> wrote: 2 CPUs should be more than enough, 16 GB of RAM is overkill. John W. Cook Systems Administrator Partnership for Strong Families ________________________________ From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> To: NT System Admin Issues <[email protected]<mailto:[email protected]>> Sent: Wed Sep 14 06:01:49 2011 Subject: Query re Virtual CPUs Hi all We are planning to deploy Sharepoint 2010 on a virtual machine running under VMware ESXi 4.1 and we were going to allocate the following resouces to it: 16 GB RAM 2 vCPUs This Sharepoint 2010 installation will be running under Windows Server 2008 R2 and will be catering for circa 10-25 users. It would also be hosting the SQL Server 2008 Standard installation. Would 2 vCPUs be enough for running Sharepoint 2010? Thanks Pierre ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
