# content database in sharepoint

- Link: https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/
- Published: 2018-10-18T04:16:34+05:30
- Author: Deviprasad Panda

## content database in sharepoint

A content database in sharepoint is not the database server itself but container
for all the content for a single web application.

[⌊manage-content-databases-1277x640⌉⌊manage-content-databases-1277x640⌉[

[⌊content database in sharepoint⌉⌊content database in sharepoint⌉[

You can have only one content database for one [web application](https://sharepointtechnicalsupport.com/web-application-in-sharepoint/)
however, you can separate content for multiple websites into multiple content databases
for a site collection. You can also use a single content database for multiple site
collections, keeping in mind that the site collection or collections represent a
single web app.

we can run the powershell command as below to get quick details however can get 
from “Central Admin -> Application Management”  under “View all Site Collections”.

    ```wp-block-code
    Get-SPContentDatabase
    ```

[⌊Get-SPContentDatabase-985x390⌉⌊Get-SPContentDatabase-985x390⌉[

[⌊Get-SPContentDatabase-1898x653⌉⌊Get-SPContentDatabase-1898x653⌉[

[⌊Get-SPContentDatabase-1896x636⌉⌊Get-SPContentDatabase-1896x636⌉[

Isolation and sharing are expressed as the difference between one site collection
using one database and numerous site collections sharing a database. The number 
of site collections using a database is also a scaling and performance issue. If
you are deploying site collections with a high workload attached and greater expectancy
for growth, make sure to use fewer [site collections per database](https://sharepointtechnicalsupport.com/maximum-number-of-site-collections-per-content-database/).
You can also plan your content database strategy by [adding databases to site collections](https://sharepointtechnicalsupport.com/create-add-a-content-database-in-sharepoint-2019/)
as they grow or [associate specific site collections only with specific content databases](https://sharepointtechnicalsupport.com/dismount-mount-content-database-in-sharepoint-2019-using-powershell/).
The latter approach lets you isolate a database serving particular site collections
from all the other databases and thus isolate the content it contains.

## boundaries and limits content databases

There can be 500 content databases per farm at max. With 200GB data per content 
database and 100TB of data per farm. 60 million items including documents and list
items. Number of site collections per content database recommended to 5,000. However,
up to 10,000 site collections are supported.2500 non-Personal site collections and
7500 Personal Sites or 10000 Personal Sites alone. find in details from [Microsoft Doc Link](https://docs.microsoft.com/en-us/sharepoint/install/software-boundaries-and-limits-0).

## content database for each site collection powershell

We can run below powershell command to know which content database your site collection
attached to.

    ```wp-block-code
    $site = Get-SPSite "http://win2016:37344/sites/SPmcse"
    write-host $site.WebApplication.ContentDatabases

    or

    $url="http://win2016:37344/sites/SPmcse"
    (Get-SPSite $url).ContentDatabase.name
    ```

[⌊Get-SPContentDatabase-1920x1303⌉⌊Get-SPContentDatabase-1920x1303⌉[

[⌊Get-SPContentDatabase-1048x480⌉⌊Get-SPContentDatabase-1048x480⌉[

##  Get SharePoint Site Content Database using Powershell | #SharePoint2019, #ContentDatabase

 Get SharePoint Site Content Database using Powershell | #SharePoint2019, #ContentDatabase

 * [change maximum upload file size limit in sharepoint](https://sharepointtechnicalsupport.com/change-maximum-upload-file-size-limit-in-sharepoint/)
 * [create add a content database in sharepoint 2019](https://sharepointtechnicalsupport.com/create-add-a-content-database-in-sharepoint-2019/)
 * [Migrate SharePoint Databases](https://sharepointtechnicalsupport.com/migrate-sharepoint-databases/)
 * [move site collection to dedicate content database](https://sharepointtechnicalsupport.com/move-site-collection-to-dedicate-content-database/)
 * [View all webs and site templates under site collection](https://sharepointtechnicalsupport.com/view-all-webs-site-templates-under-site-collection/)

### Share this:

 * [  X ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=twitter)
 * [  Facebook ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=facebook)
 * [  WhatsApp ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=jetpack-whatsapp)
 * [  Email ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?subject=%5BShared%20Post%5D%20content%20database%20in%20sharepoint&body=https%3A%2F%2Fsharepointtechnicalsupport.com%2F2018%2F10%2F18%2Fcontent-database-in-sharepoint%2F&share=email)
 * [  Telegram ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=telegram)
 * [  LinkedIn ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=linkedin)
 * [  Tumblr ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=tumblr)
 * [  Pinterest ](https://sharepointtechnicalsupport.com/2018/10/18/content-database-in-sharepoint/?share=pinterest)

### Like this:

Like Loading…

### _Related_