Get all SharePoint database sizes

SharePoint creates 15+ databases during installation and configuration and it’s possible you want to know the size of each database without connecting to the database server or manually checking each size.

You can easily get the size of each database using the following PowerShell one-liner:

Get-SPDatabase | Sort-Object disksizerequired -desc | %{write-host  “Size: $($_.disksizerequired/1mb)MB – Database: $($_.Name)”}

 

image

Note that these numbers are the space used in the database.

For example:

  • WSS_UsageApplication has a database size of 6231,13MB and has 1819,30MB space available.
    The actual data is 4411MB
  • WSS_Content_Portal has a database size of 216,50MB and has 30,30MB space available.
    The actual data is 186,2MB

Leave a Reply

Your email address will not be published. Required fields are marked *