Limiting Sharepoint 2010 Memory on an All in One B.I. Box

With all of these new fandangle self service Business Intelligence tools hanging off Sharepoint now, you may want to protect the precious box against unintentionally melicious drag and drop power moves.   Sharepoint and SQL Server on the same box is an easy equation and easy to install, however if things start to bog down and you have other web applications running on the same box, you may want to set a limit on the Physical Memory Limit (Kb) property.

Open IIS, go to the default Sharepoint application pool, select Advanced Settings and enter a value for the Physical Memory Limit (Kb).  The best reference I could find on an easy approach is outlined here …

http://blog.walteralmeida.com/2011/07/iis7-private-memory-limit-versus-virtual-memory-limit.html

There is also a really good run down on each of the Application Pools outlined here – thanks Joel! http://blogs.msdn.com/b/joelo/archive/2007/10/29/sharepoint-app-pool-settings.aspx

Of course you can also cap the memory that SQL Server uses and/or use the SQL Server Resource Governor to stop processes running away with your server’s resources.

Failing this, you could get a business case together and go for a distributed architecture.

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s