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

Getting SQL Instance Edition or service pack for SQL 2012

I have posted the below query before for SQL Server 2005, 2008 and 2008 R2 on https://www.sharepointfire.com/?p=138 and it is still usable for SQL Server 2012

SELECT
SERVERPROPERTY(‘Edition’) AS ‘Edition’,
SERVERPROPERTY(‘ProductVersion’) AS ‘ProductVersion’,
SERVERPROPERTY(‘ProductLevel’) AS ‘ProductLevel’,
SERVERPROPERTY(‘ResourceLastUpdateDateTime’) AS ‘ResourceLastUpdateDateTime’,
SERVERPROPERTY(‘ResourceVersion’) AS ‘ResourceVersion’
GO

(It is possible you need to change the ‘)

 

image