Post

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 – […]

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

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Archive