NTBuddy

Upper Limit Numbers / Performance

Based on real-life scenarios and guidelines below is where you should set your maximums for your SharePoint installations 

Stay below these numbers. The only hard limit one is the maximum file size of 2 gigabytes as this is a SQL Server limit.

 

Element	Guideline
Maximum number of site collections in an Office SharePoint Server 2007 database	50,000
Maximum number of web sites in a site collection	250,000
Maximum number of lists in a site	2,000
Maximum number of items in a list	10,000,000
Maximum number of documents in a document library	2,000,000
Maximum number of documents in a folder	2,000
Maximum number of size in a file	2 Gigabyte (SQL Limit)
Maximum number of indexed items in an SSP	50,000,000
Maximum number of search scopes in a site collection	1,000
Maximum number of profiles in an SSP	5,000,000
Web parts - no more than 50 per page	50

 

1. Performance
• Processor
• Memory
• Disk
• ASP.Net
• Network IO
• Share Point Specific
• Search archival
• Search indexer
• Search schema
• Gather process
• Search gatherer
2. Generic Counters to monitor
• % processor time (should be under 75-85%) - If over continuously get a new / faster CPU
• Bytes Total/sec (should be under 40-50% )
• Logical Disk
• % Idle Time
• % Free Space
• Physical Disk
• Avg./ Disk Queue Length - should be below 2
• Paging  file
• % Usage
• % Usage Peak
• Memory
• Available Megabytes Bytes
• ASP.Net Applications AND ASP.Net
• Request Wait Time - lower is better
• Cache
• Async Fast read/sec
• Read Aheads/sex
3. SharePoint Specific
• SharePoint Search Archival Plug-in - higher is bad
• Blocked documents
• SharePoint Search Gather
• Idle threads - lower is better
• SharePoint Search Gather Process - lower is better
• Waiting Documents
• SharePoint Search Indexer Catalog - lower is better
• SharePoint Search Schema Plug-in
• Web Service
• Microsoft SharePoint Administration
• SharePoint Central Administration v3
• SharePointSSPWeb
4. Page Request Cycles
• Master page
• Page layout page
• Content of the page
• Content for Web Parts
5. Have an Initial Baseline for Performance