Check SQL Server Database Size

Published on Wednesday, August 20, 2014

There are 2 ways to check SQL Server database size:

1: Use script:

sp_spaceused: Get information about the total size of the database

sp_spaceused ‘TableName’: Get information about the size of specific table

2: Use SQL Server Management Studio operatons: Right click database, select Reports > Standard Reports, then you can see multiple database disk usage options.

image

The following is the result for Disk Usage: image