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

Products

• IT Management Suite

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