Know Your Limits: Capacity Planning in SharePoint 2010

Know Your Limits: Capacity Planning in SharePoint 2010

Posted on October 11, 2010 by Kelly Rusk in SharePoint

PerformancePoint Services limits

The following table lists the recommended guidelines for PerformancePoint Services in Microsoft SharePoint Server 2010.

Limit	Maximum value	Limit type	Notes
Cells	1,000,000 per query on Excel Services data source	Boundary	A PerformancePoint scorecard that calls an Excel Services data source is subject to a limit of no more than 1,000,000 cells per query.
Columns and rows	15 columns by 60,000 rows	Threshold	The maximum number of columns and rows when rendering any PerformancePoint dashboard object that uses a Microsoft Excel workbook as a data source. The number of rows could change based on the number of columns.
Query on a SharePoint list	15 columns by 5000 rows	Supported	The maximum number of columns and row when rendering any PerformancePoint dashboard object that uses a SharePoint list as a data source. The number of rows could change based on the number of columns.
Query on a SQL Server data source	15 columns by 20000 rows	Supported	The maximum number of columns and row when rendering any PerformancePoint dashboard object that uses a SQL Server table data source. The number of rows could change based on the number of columns.

Print

PDF

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Kelly Rusk

Kelly Rusk is the SharePoint ECM Team Lead at Concurrency. He works closely with clients to implement comprehensive SharePoint solutions. A graduate of the Monterey Institute of International Studies, he is an AIIM ECM Specialist / ERM Master and holds Microsoft certifications in SharePoint and Server technologies. When not running through SharePoint projects, Kelly can be found outside distance running.

All Articles From Kelly Rusk | LinkedIn Profile

Test

One Response

links for 2011-09-22 « Jet Grrl

10.11.10

[...] Know Your Limits: Capacity Planning in SharePoint 2010 | Concurrency Blog (tags: sharepoint architecture sql) Like this:LikeBe the first to like this post. [...]