Return
-
Title
How to Find Out Size of Tables in NMS Database -
Description
When the NMS database is getting too big and it is necessary to find out what tables are consuming most of disk spaces. -
Cause
Data retention is high, old data may not purge automatically or there is an increase in enterprise traffic. -
Resolution
Execute the below SQL statements on the NMS database in Microsoft SQL Server Management Studio.
The results are sorted descending by rows. The tables show on top of the result window are those using more disk spaces.
--------------------------------------------------------------------------
SELECTcast('[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' as varchar(50)) AS fulltable_name,cast(SCHEMA_NAME(t.schema_id) as varchar(16)) AS schema_name,cast(t.name as varchar(50)) AS table_name,i.rowsFROM sys.tables AS t INNER JOIN sys.sysindexes AS i ON t.object_id = i.id AND i.indid < 2ORDER BY i.rows desc