Commands for SharePoint Content Databases

Use below commands to get Content Databases size and Data base size for each Site Collection:

Content Databases in Farm

Get-SPDatabase : Sort-Object disksizerequired-desc: Format-Table Name, @(Label = “Size in MB”; eXPRESSION = ($_.disksizerequired/1024/1024))

Database size for each site collection

Get-SPSite -Limit All -ContentDatabase <DatabaseName> :select url, @(label=”Size”;Expression=($_.usage.storage))

 

Advertisements