Category Archives: Performance SharePoint

Troubleshooting Performance Issues

Developer Dashboard SharePoint 2010

The Developer Dashboard is a new feature in SharePoint 2010 that helps a developer or system administrator to troubleshoot problems with page components and performance bottlenecks.

In order to monitor usage and resource consumption, Developer Dashboard is using the following counters:

Continue reading

SharePoint 2007 People Picker performance issues

Every time when you want to grant permission for a user or group in a SharePoint application you will use this SharePoint people-picker interface.

clip_image002[4] clip_image004[4]

How does people-picker work?

When you type a keyword to find a user or a group, people-piker will first make a query on the content database and if there are no results, it will make the second LDAP query on the DC. More info in this article

Continue reading

Performance with SharePoint 2010 Large lists – List view throttling

SharePoint 2010 lists and libraries can hold a maximum number of 30,000,000 items. In a SharePoint site the list view threshold is 5000 for users and 20,000 for auditors and administrators.

SharePoint large list and libraries operations like Delete/Update are one of the top performance killers.

What can we do if the server is overloaded when we access large lists and libraries? One solution is list view throttling.

Continue reading

Performance and Blob Storage

Two months ago I was at a SharePoint conference where I saw a nice presentation of Dan Holme regarding blob storage.

As per Microsoft definition – a binary large object (BLOB) is a large block of data stored in a database that is known by its size and location instead of by its structure — for example a Microsoft Office 2010 document or a video file.

Continue reading