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))
Leave a Comment