In this simple article, I would like to share how to check DB size. Sometimes when working in a Database, we may need to know the current space occupied by that particular DB. Based on the size, we need to take action.
There are three easiest ways to check it,
- Using T-SQL Statement
- Using SP sp_spaceused
- Using SSMS
Using T-SQL Statement
When the about T-SQL statement is executed, it will list all the databases with the current disk space occupied.
Using Stored Procedure
By using sp_spaceused, we can get the current database’s disk space.
database_size column in the first result set provides the disk space occupied by the current database.
To know size Go to Server Explorer -> Expand it -> Right-click on Database -> Choose Properties -> In popup window choose General tab ->See Size property
In this simple tips and tricks article, we discussed finding the Database size. Hope this article was very useful and we will discuss more tips and tricks in our upcoming articles. Please share your feedback in the comment section.