Category Archives: SharePoint 2010

Troubleshooting tips and tricks for SharePoint 2010

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

SharePoint Tempdb

After having analyzed this TechNet article http://technet.microsoft.com/en-us/library/cc298801(office.12).aspx regarding Physical storage recommendations (Office SharePoint Server) I have decided to create a post related to tempdb.

Here you have a list of actions that you can apply on tempdb

1. Check where temp db is located

SELECT name, physical_name AS CurrentLocation

FROM sys.master_files

WHERE database_id = DB_ID(N’tempdb’);

Continue reading

Performance issues on SharePoint servers without Internet Connection

Recently I have observed this behavior on SharePoint servers without Internet connection
 
Issue:
Randomly, you are experiencing performance issues when navigating to a SharePoint site

Resolution:

1. Download the following CAB from Microsoft website http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootstl.cab

a. Unzip the CAB on all the SharePoint Servers

b. Install STL file

Or

Continue reading