Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Multi-Cloud Service Orchestration & Delivery Platform

How to Modify Database Capacity Settings in SharePoint 2010?

H

Microsoft has come up with the following benchmarks, beyond which performance suffers.

Content db Recommended Default
Site Collection in Single Content db 10000 15000

Navigate to Central Administration and then Application Management

Central Administration> Application Management
Click on Manage Content databases Under Databases
Click on Database Name On which you want to modify capacity setting.

Modify the Maximum Number of Site per Content db. (15000 to 10000)

According to Microsoft, you can have up to 50,000 Site Collections in a single web application. The bigger question I think you should be asking yourself is, how many Site Collections do you want to put in any single content database? When you look at SharePoint from a recovery perspective it is important to limit the size of your content databases so that you can manage your backups and restores. Each Site Collection can only reside in a single content database, though you can have any number of collections in a content db. So, while I can have 50,000 collections in my web app, how many content databases will that be and how many of those collections will be in each db?

Microsoft also recommends no more than 100 content databases per Web app. So, let’s assume you don’t want databases larger than 100 GB , and your site collections had an average of 10GB quotas – you could have 10 site collections per content database (not including 2nd stage Recycle Bin) Using some simple math and introducing a reality check, that’s actually about 1,000 site collections per Web app.

Ref: SharePoint 2010 Performance and Capacity Planning

Multi-Cloud Service Orchestration & Delivery Platform

Connect with MachSol

MachSol is Microsoft Certified Partner and Microsoft Validated Vendor having years of experience in cloud automation industry.

Categories