How to Find Out Size of Tables in NMS Database (131609)

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

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.
--------------------------------------------------------------------------
SELECT
cast('[' + 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.rows
FROM sys.tables AS t INNER JOIN sys.sysindexes AS i ON t.object_id = i.id AND i.indid < 2
ORDER BY i.rows desc

Feedback submitted.

Was this article helpful?

[Select Rating]

Title