# Get Database Size for all SharePoint Data Bases using PowerShell

- Link: https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/
- Published: 2015-05-02T14:10:24+05:30
- Author: Deviprasad Panda

Get Database Size for all SharePoint Data Bases using PowerShell

Add-PSSnapin microsoft.sharepoint.powershell

$size = 0

foreach ($db in Get-SPContentDatabase)

{

$size = $size + $db.DiskSizeRequired

}

$cdbs = “{0:N2}” -f($size/1gb)

$ssa = Get-SPEnterpriseSearchServiceApplication

$topo = $ssa | Get-SPEnterpriseSearchTopology  -Active

$indexcomponent = (Get-SPEnterpriseSearchComponent -SearchTopology $topo | ?{$_.
name -like “*index*”})[0]

$folder = $indexcomponent.RootDirectory

$indexsize = “{0:N2}” -f ((Get-ChildItem $folder -Recurse | Measure-Object -sum 
Length).sum/1GB)

$dbs = Get-SPDatabase

cls

write-host “————————————————————————————–” -fore green

Get-Date

write-host “”

write-host “————————————————————————————–” -fore green

write-host “SUM: Content DB Size in GB: ” -NoNewline -fore White

write-host $cdbs -fore Yellow

write-host “————————————————————————————–” -fore green

write-host “Index Size (Localhost) on Disk in GB: “-NoNewline -fore white

write-host $indexsize -fore Yellow

write-host “————————————————————————————–” -fore green

$sum_all_dbs = 0

foreach ($db in $dbs)

{

write-host $db.name “DB Size in GB: ” -NoNewline -fore White

$dsr = “{0:N2}” -f ($db.DiskSizeRequired/1gb)

write-host $dsr  -fore Yellow

$sum_all_dbs=$sum_all_dbs+$db.DiskSizeRequired

}

write-host “————————————————————————————–” -fore green

write-host “SUM: Usage of all SharePoint DBs in GB: ” -NoNewline -fore White

$sum_all_dbs = “{0:N2}” -f ($sum_all_dbs/1gb)

write-host $sum_all_dbs -fore Yellow

write-host “————————————————————————————–” -fore green

### Share this:

 * [  X ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=twitter)
 * [  Facebook ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=facebook)
 * [  WhatsApp ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=jetpack-whatsapp)
 * [  Email ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?subject=%5BShared%20Post%5D%20Get%20Database%20Size%20for%20all%20SharePoint%20Data%20Bases%20using%20PowerShell&body=https%3A%2F%2Fsharepointtechnicalsupport.com%2F2015%2F05%2F02%2Fget-database-size-for-all-sharepoint-data-bases-using-powershell%2F&share=email)
 * [  Telegram ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=telegram)
 * [  LinkedIn ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=linkedin)
 * [  Tumblr ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=tumblr)
 * [  Pinterest ](https://sharepointtechnicalsupport.com/2015/05/02/get-database-size-for-all-sharepoint-data-bases-using-powershell/?share=pinterest)

### Like this:

Like Loading…

### _Related_