If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then click Disk Usage).

 

However, if you prefer to use T-SQL to manage your databases, you’ll need to run a query to find all databases sizes.

Query to find all databases sizes, ssms union-vs-union-all

Leave a Comment