Book Image

Microsoft SharePoint 2010 Administration Cookbook

By : Peter Serzo
Book Image

Microsoft SharePoint 2010 Administration Cookbook

By: Peter Serzo

Overview of this book

Collaboration and content management are the major business needs of every organization in this increasingly global and connected environment. Microsoft SharePoint is a solution to these needs that offers a software platform that facilitates collaboration and provides content management features for the effective implementation of business processes. With a vast amount of functionality available with SharePoint, it is easy to get confused in carrying out administrative tasks. Microsoft SharePoint 2010 Administration Cookbook starts off by demonstrating the various upgrading and post-upgrading tasks to be performed in SharePoint 2010. Next come recipes for managing SharePoint service-level applications and for monitoring the SharePoint environment. The book introduces one of the best new tools that should be in your arsenal, PowerShell, and the commands you will need to script your tasks with Powershell. Collaboration and content management are the most important features of SharePoint and this book contains many recipes that focus on improving them. Enterprise monitoring and reporting are also covered in detail so that you can ensure that your SharePoint implementation is up and running all the time. You will find recipes to manage and customize SharePoint Search. When you are half way through the book, you will explore more advanced and interesting topics such as customizing and securing the SharePoint environment. You will learn to extend SharePoint to include features similar to social networking sites such as Facebook and Twitter. Lastly, the book covers backup and recovery solutions for SharePoint so that you can ensure that your system is protected from data loss and virus attacks.
Table of Contents (17 chapters)
Microsoft SharePoint 2010 Administration Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface

Configuring Resource Throttling (large lists)


At the very heart of SharePoint are lists. Just about everything in SharePoint is a list. It can be stated that SharePoint content is list driven.

One of the shortcomings of the previous version of SharePoint was that performance began to degrade if a list had more than 2000 items. This doesn't mean if a list had 2001 items, the performance degradation was noticeable. A SharePoint list could have millions of records. Let's break down exactly what happens when a user requests information from a list.

A user clicks on a link to see the items in a list. It invokes a query back to SQL to pull those items and present them. The query looks at how many columns are on that list and does a "select all" operation. The more columns in a list, the more data that is returned, and the longer it takes to select all of that data because it is number of rows multiplied by number of columns.

Resource throttling is a set of configuration items built into the software...