How to get size of each table using SQL Management Studio

Sometimes your DB storage bloated so much, without knowing what caused it. Fortunately, there is an easy way to check using SQL Management Studio (SMSS). In this scenario, I am using SQL Management Studio 18.
  1. Open SQL Management Studio and connect to your DB
  2. Click View -> Object Explorer (F7) -> Databases
  3. From the list of databases, navigate to the DB you want to investigate
  4. Right-click on the header of the table list, choose Data Space Used (KB)
  5. Click on the Data Space header to sort based on the biggest to lowest data usage. Not surprising, usually the culprit is the log that does not have an auto-delete function.


Popular posts from this blog

Hiren can not load the CD ROM Driver

Enable PHP opcache extension on Windows XAMPP

Sunrose USB Fingerprint Reader Driver