SharePoint Max Dragon - checks for capacity planning limits

More info? Check the SharePoint Dragons blog at http://sharepointdragons.com/ !

There's also a 2013 version: Maxer for SharePoint 2013 at http://gallery.technet.microsoft.com/Maxer-for-SharePoint-2013-52208636

Maxer for SharePoint 2010 is a command line tool that checks for capacity planning limits as described per the Planning section of the TechNet Wiki SharePoint 2010 Best Practices overview page at http://social.technet.microsoft.com/wiki/contents/articles/8666.sharepoint-2010-best-practices-en-us.aspx.

The Maxer zip file can be extracted on a server of the SharePoint farm. To execute it, all you need to do is type maxer at the command line. It will then start analyzing your entire SharePoint farm (so make sure the user account executing the tool is extremely powerful, otherwise the analysis will fail) and create a text file called overviews.txt in the same directory as Maxer. Depending on the size of your farm, this may (or may not) take a long time and can be a CPU intensive operation, so be careful to plan this off hours when doing this in a production environment.

Since this is the first version, a limited set of 10 features is included. Also, error handling is quite rudimentary. Community feedback will decide the future direction of Maxer for SharePoint 2010.

The v1.0 feature set contains the following capacity limit checks:

A single web application can only have 250,000 site collections.
A single web application can only have 300 content databases.
A single content database can only have 2000 site collections.
A single site collection can only have 2 million users.
A single user can only be a member of 5000 groups.
A single site collection can only have 10,000 SharePoint groups.
A single SharePoint security group can only have 5000 AD
principles/users.
A single site collection can only have 250,000 sites and subsites.
A single web site can only have 2000 sub web sites.
A single list can only have 30,000,000 items.

The top feature request that will be implemented next is to have the option to specify whether a full blown report should be generated or only a report of capacity violations. Currently, Maxer only supports the full blown report.

Let’s discuss some code concerning these checks… Looping thru all web applications goes like this:

Edit|Remove

SPFarm farm = SPWebService.ContentService.Farm;
SPWebApplicationCollection webApps = SPWebService.ContentService.WebApplications;
 
if (webApps != null)
 {
   foreach (SPWebApplication webApp in webApps)
   {
     …
  }
}

SPFarm farm = SPWebService.ContentService.Farm; 
SPWebApplicationCollection webApps = SPWebService.ContentService.WebApplications; 
  
if (webApps != null) 
 { 
   foreach (SPWebApplication webApp in webApps) 
   { 
     … 
  } 
}

Determine the number of content databases within a web application using the following code:

Edit|Remove

var contentDbCount = CurrentWebApp.ContentDatabases.Count;

var contentDbCount = CurrentWebApp.ContentDatabases.Count;

Loop thru all content databases within a web application like this:

Edit|Remove

foreach (SPContentDatabase cdb in CurrentWebApp.ContentDatabases)
 {
  …
 }

foreach (SPContentDatabase cdb in CurrentWebApp.ContentDatabases) 
 { 
  … 
 }

Determine the number of site collections within a web application:

Edit|Remove

var siteCount = CurrentWebApp.Sites.Count;

var siteCount = CurrentWebApp.Sites.Count;

Loop thru all site collections within a web application:

Edit|Remove

foreach (SPSite site in CurrentWebApp.Sites)
 { 
  …
 }

foreach (SPSite site in CurrentWebApp.Sites) 
 {  
  … 
 }

Determine the number of sites within a content database:

Edit|Remove

int sites = CurrentContentDb.Sites.Count;

int sites = CurrentContentDb.Sites.Count;

Get all users belonging to a site collection:

Edit|Remove

int users = CurrentSite.OpenWeb().SiteUsers.Count;

int users = CurrentSite.OpenWeb().SiteUsers.Count;

Loop thru all users of a site collection:

Edit|Remove

foreach (SPUser user in CurrentSite.OpenWeb().SiteUsers)
{
  …
}

foreach (SPUser user in CurrentSite.OpenWeb().SiteUsers) 
{ 
  … 
}

Determining how many groups a user is a member of:

Edit|Remove

int groups = CurrentUser.Groups.Count;

int groups = CurrentUser.Groups.Count;

Get all security groups within a site collection:

Edit|Remove

int groups = CurrentSite.OpenWeb).SiteGroups.Count;

int groups = CurrentSite.OpenWeb).SiteGroups.Count;

Loop thru all security groups within a site collection:

Edit|Remove

foreach (SPGroup group in CurrentSite.OpenWeb).SiteGroups)
{
  …
}

foreach (SPGroup group in CurrentSite.OpenWeb).SiteGroups) 
{ 
  … 
}

Determine the amount of users within a SharePoint security group:

Edit|Remove

int users = CurrentGroup.Users.Count;

int users = CurrentGroup.Users.Count;

Count all web sites in a site collection, including sub sites:

Edit|Remove

int siteCount = CurrentSite.AllWebs.Count;

int siteCount = CurrentSite.AllWebs.Count;

Looping thru every web site in a site collection:

Edit|Remove

foreach (SPWeb web in CurrentSite.AllWebs)
{
  … 
}

foreach (SPWeb web in CurrentSite.AllWebs) 
{ 
  …  
}

Determining the amount of sub sites of a web site:

Edit|Remove

int subSites = CurrentWeb.Webs.Count;

int subSites = CurrentWeb.Webs.Count;

Looping thru the sub sites of a web site:

Edit|Remove

foreach (SPList list in CurrentWeb.Lists)
{ 
 …
}

foreach (SPList list in CurrentWeb.Lists) 
{  
 … 
}

A shortened example output (taken from the overviews.txt file) looks like this:

Overview generated by the Maxer for SharePoint 2010

Maxer was created by Nikander Bruggeman and Margriet Bruggeman of Lois &
Clark IT Services
Web site: http://www.loisandclark.eu
Blog: http://www.sharepointdragons.com

Web application name: SharePoint - 80
There are 1 content databases within
web app SharePoint - 80. The maximum allowed is 300.
Content database
WSS_Content has 5 site collections. The max. allowed is 2000.

Analyzing site collection http://astro
There
are 6 users in site collection http://astro. A max of
2,000,000 users is allowed.
User anton antona is a member of 2 groups. A max
of 5000 is allowed.
User billg is a member of 1 groups. A max of 5000 is
allowed.
User LOISANDCLARK\administrator is a member of 1 groups. A max of
5000 is allowed.
User NT AUTHORITY\Authenticated Users is a member of 0
groups. A max of 5000 is allowed.
User NT AUTHORITY\LOCAL SERVICE is a member
of 0 groups. A max of 5000 is allowed.
User System Account is a member of 1
groups. A max of 5000 is allowed.

There are 5 groups in site collection http://astro. A max of 10,000 is allowed.
Group My
dev sc Members has 1 users. A max of 5000 is allowed.
Group My dev sc Owners
has 3 users. A max of 5000 is allowed.
Group My dev sc Visitors has 0 users.
A max of 5000 is allowed.
Group Records Center Web Service Submitters has 1
users. A max of 5000 is allowed.
Group Viewers has 0 users. A max of 5000 is
allowed.

There are 1 sites in site collection http://astro.
A max of 250,000 is allowed.
Web site My dev sc has 0 sub sites. A max of
2000 is allowed.
There are 0 items in list C6. A max of 30,000,0000 is
allowed.
There are 1 items in list Content Organizer Rules. A max of
30,000,0000 is allowed.
There are 0 items in list Content type publishing
error log. A max of 30,000,0000 is allowed.
There are 4 items in list
Converted Forms. A max of 30,000,0000 is allowed.
There are 0 items in list
cusst. A max of 30,000,0000 is allowed.
There are 2 items in list Customized
Reports. A max of 30,000,0000 is allowed.
There are 3 items in list Drop Off
Library. A max of 30,000,0000 is allowed.
There are 0 items in list
ExtListMargriet. A max of 30,000,0000 is allowed.
There are 0 items in list
Form Templates. A max of 30,000,0000 is allowed.
There are 0 items in list
fpdatasources. A max of 30,000,0000 is allowed.
There are 4 items in list
HappyDays. A max of 30,000,0000 is allowed.
There are 1 items in list
LearnCustomList. A max of 30,000,0000 is allowed.
There are 0 items in list
List Template Gallery. A max of 30,000,0000 is allowed.
There are 2 items in
list Lounge. A max of 30,000,0000 is allowed.
There are 0 items in list M2. A
max of 30,000,0000 is allowed.
There are 0 items in list M3. A max of
30,000,0000 is allowed.
There are 0 items in list M4. A max of 30,000,0000 is
allowed.
There are 0 items in list MargrietExtListMaandag. A max of
30,000,0000 is allowed.
There are 22 items in list Master Page Gallery. A max
of 30,000,0000 is allowed.
There are 1 items in list MyCustList. A max of
30,000,0000 is allowed.
There are 2 items in list MyCustomList. A max of
30,000,0000 is allowed.
There are 2 items in list MyDox. A max of 30,000,0000
is allowed.
There are 1 items in list MyLinks. A max of 30,000,0000 is
allowed.
There are 3 items in list MyMetalList. A max of 30,000,0000 is
allowed.
There are 3 items in list MyPrintList. A max of 30,000,0000 is
allowed.
There are 0 items in list MyProductList. A max of 30,000,0000 is
allowed.
There are 0 items in list MyProductServiceList2. A max of
30,000,0000 is allowed.
There are 0 items in list MyRequests. A max of
30,000,0000 is allowed.
There are 0 items in list P3. A max of 30,000,0000 is
allowed.
There are 0 items in list P4. A max of 30,000,0000 is
allowed.
There are 0 items in list P5. A max of 30,000,0000 is
allowed.
There are 0 items in list pix. A max of 30,000,0000 is
allowed.
There are 0 items in list Pro1. A max of 30,000,0000 is
allowed.
There are 0 items in list ProductList. A max of 30,000,0000 is
allowed.
There are 0 items in list ProductListMargriet. A max of 30,000,0000
is allowed.
There are 0 items in list ProductPartList. A max of 30,000,0000
is allowed.
There are 0 items in list ProductPartList2. A max of 30,000,0000
is allowed.
There are 0 items in list ProductServiceList. A max of
30,000,0000 is allowed.
There are 1 items in list Site Assets. A max of
30,000,0000 is allowed.
There are 0 items in list Site Pages. A max of
30,000,0000 is allowed.
There are 2 items in list Solution Gallery. A max of
30,000,0000 is allowed.
There are 0 items in list Style Library. A max of
30,000,0000 is allowed.
There are 3 items in list SuperJokerList. A max of
30,000,0000 is allowed.
There are 0 items in list Tasks. A max of 30,000,0000
is allowed.
There are 5 items in list TaxonomyHiddenList. A max of
30,000,0000 is allowed.
There are 5 items in list TestDox. A max of
30,000,0000 is allowed.
There are 20 items in list Theme Gallery. A max of
30,000,0000 is allowed.
There are 11 items in list User Information List. A
max of 30,000,0000 is allowed.
There are 67 items in list Web Part Gallery. A
max of 30,000,0000 is allowed.
There are 0 items in list wfpub. A max of
30,000,0000 is allowed.
There are 12 items in list Workflow History. A max of
30,000,0000 is allowed.
There are 8 items in list Workflows. A max of
30,000,0000 is allowed.