Education & Training
Services & Support
CA Automic Community
CA Automic Workload Automation
to create and rate content, and to follow, bookmark, and share content with other members.
Automic database table size reports
Discussion created by
on Jun 2, 2017
on Jun 2, 2017 by Mike_Halliday_7686
Show 0 Likes
Does anyone have any scripts or queries that will report out on the size of the tables in the Automic DB itself?
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Jun 2, 2017 3:57 AM
I use the below query for checking table usage on MSSQL databases
DECLARE @tempResults TABLE
INSERT INTO @tempResults
EXEC sp_MSforeachtable 'sp_spaceused "?"'
cast(left([reserved],len([reserved])-3) as int) as [Reserved KB],
cast(left([data],len([data])-3) as int) as [data KB],
cast(left([index_size],len([index_size])-3) as int) as [index_size KB],
cast(left([unused],len([unused])-3) as int) as [unused KB]
LEFT OUTER JOIN sys.objects o ON t.[name] = o.[name]
[is_ms_shipped] = 0 AND
[type] = 'U'
[Reserved KB] DESC
Show 1 Like
Retrieving data ...
Clarity PPM Demo Series
MSP Integration Buyin
SQL Query for OPEN timesheets
Issues with RSA and CA PAM integration
Element Locking during Package Processing
[Quick question] - How to check the DB size on SQL server ?