How do I determine what the database table sizes are per solution?

book

Article ID: 180080

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Environment

ITMS 8.x

Resolution

Question
How do I determine what the database table sizes are in the Altiris database per solution?

Answer
You can run the following SQL script in SQL Management Studio to determine which tables are the largest:

-- Approx table size count
select
     [Table] = so.[name]
    ,[Rows] = max(si.[rows])
    ,[Index Pages] = max(si.[dpages])
    ,[Reserved] = max(si.[reserved])
    ,[Used] = max(si.[used])
from sys.objects so
join sysindexes si on si.id = object_id(so.[name])
where so.[type] = 'U'   and si.[rows] > 0
group by so.[name]
order by 2 desc