Check the size of database and table in Microsoft SQL Server

Check the size of Database and table in Microsoft SQL Server

Check the Size of Database in SSQL Server

exec sp_spaceused


database_name   database_size   unallocated space
adventureworks  17899.13 MB     5309.39 MB

Find the Size of Database files in Microsoft SQL Server

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) like '%AdventureWorks%'
order by SizeMB desc


DatabaseName    Logical_Name       Physical_Name                    SizeMB
ADVENTUREWORKS  ADVENTUREWORKS     D:\MSSQL\Data\adventure.mdf      21453           AVENTUREWORKS   ADVENTUREWORKS_log D:\MSSQL\Data\adventure.ldf      5234

Check the size of database


Check size of data files in database

USE AdventureWorks;
SELECT file_id, name, type_desc, physical_name, size, max_size
FROM sys.database_files ;

Check Size of Table

sp_spaceused 'MyTable'


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.