Geeks With Blogs
SharePoint & SQL Thoughts
I thought it would nice to put something out there that can help someone who’s looking to either deploy, re-deploy and migrate contents from a database that has grown too large.
When planning SharePoint deployment it’s always good to have a clear picture of where your site is going so that you can make the necessary arrangement to put it under control. Microsoft has a good documentation on Architecture to help you answer the hard questions, but how, when and where do you start on capacity planning?
Some of the things to put in mind during the planning phase include:
1.       Maximum size of a list and list containers, the recommendation is to not have more than 2,000 items at a given level. The maximum number of items supported in a list with recursive folders is up to 5 million items.
2.       Maximum database size per site collection equates to about 200GB which is driven as per the SLA on your database recovery time.
3.       A maximum of 20 SSP’s with 4 as best practice for your SharePoint farm to reduce the administration procedures.
4.       MOSS 2007 and WSS 3.0 do not support the /3GB switch to address the application’s memory allocation.
5.       32-bit vs 64-bit hardware – If you are budgeting for hardware be sure to budget for X64-bit to get better performance for your application. Also future releases of SharePoint will be based on X64-bit hardware.
So how do you determine the required number of servers for n number of users? Microsoft released a free download of System Center Capacity Planner 2007 (SCCP) originally an Exchange Server Deployment tool but now can be used for SharePoint Farm Architecture with addition of SharePoint 2007 and WSS 3.0 Models http://www.microsoft.com/systemcenter/en/us/capacity-planner.aspx .
To simulate the load, you can use Visual Studio 2008 Team Suite.
As best practice, test your farm architecture prior to deploying it to production environment.
                                                                                                                        
Posted on Monday, March 30, 2009 9:03 PM | Back to top


Comments on this post: Capacity Planning in SharePoint

# re: Capacity Planning in SharePoint
Requesting Gravatar...
Hello,
I am attempting a SharePoint 2007 installation and am doing some preliminary testing using the SharePoint Capacity Planner, which when installing, requires the System Center Capacity Planner 2007 v2.0, before it will continue to install. I have found the SCCP 2007 is no longer available on the MS site and was wondering if you could please email me a copy. It would be greatly appreciated. Thanks.

Bradley Weller
bweller@gcfd.org

Left by Bradley Weller on Jan 26, 2011 10:43 AM

# re: Capacity Planning in SharePoint
Requesting Gravatar...
When I tried to jump into the asp.net work flow platform.I found out there are really very few simple and basic examples available in the internet.
The Best Salon Websites
Left by david khannan on Jun 22, 2011 6:28 AM

# re: Capacity Planning in SharePoint
Requesting Gravatar...
The concept is really simple.You have a web page default.aspx with a text box and a button.You enter an amount in the text box and if the amount is more than 100 you are redirected to the credit.aspx and if less to the debit.aspx.
Tractors for sale
Left by micheal on Jun 22, 2011 6:29 AM

# re: Capacity Planning in SharePoint
Requesting Gravatar...
This capacity planning is a great initiative to help change. I'm excited to see such resources being used.
Left by Asset Based Giving on Jun 29, 2011 12:24 PM

# re: Capacity Planning in SharePoint
Requesting Gravatar...
The capacity planning in sharepoint is a very interesting concept. I look forward to seeing how people will use it for many other purposes.
Left by Hospital Jobs on Jul 11, 2011 3:59 PM

# re: Capacity Planning in SharePoint
Requesting Gravatar...
"Because SharePoint Server works often in environments where databases are managed by separate managers SQL Server database, this document is intended for the joint use of the executors and SharePoint server farm and SQL Server administrators of databases. It is assumed that significant understanding of both SharePoint Server and SQL Server. "
jogos online
Left by mazar on Jul 28, 2011 3:20 PM

# re: Capacity Planning in SharePoint
Requesting Gravatar...
Writing advises you on choosing a storage architecture, disk and RAID types. There is a table of guidelines for estimating memory requirements and some suggestions about the requirements of the network topology. In SQL Server Configuration section advises that SharePoint Server 2010 was designed to operate in several mid-sized servers instead of a couple grand. The final point in the article provides a general guide to monitor the performance of your system.
jogos de carros

Left by mazar on Jul 28, 2011 3:21 PM

Comments have been closed on this topic.
Copyright © Leonard Mwangi | Powered by: GeeksWithBlogs.net