How to get Table and Database size using T-Sql

Introduction

Today I would like to check my database and other few table size in online database. For that I have been use the system stored procedure to get the tables and database size. Here would like share with you.

How to Get Database Size?

Just copy below script and run in your server management studio or query analyser.

EXEC sp_spaceused

The sp_spaceused is a system procedure. this is work without argument or with argument as well. For example if you need to take database size, you don’t need to pass the any arguments.

Output

How to Get Table Size?

EXEC sp_spaceused 'userpointsdetail'

In above script, i try to view the size of the UserPointDetails table size.

Output

You able to see how many KB have been allocated and how many Kb has been used. even you can see how many rows has in this table.

References

http://msdn.microsoft.com/en-us/library/ms188776.aspx

Hopes help.thank for reading.