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 ...
How to apply Service_Type in a custom field
Get Assigned Access Role with Policy Xpress
Call Ldap from form handlers in Identity Portal
[Quick question] - How to check the DB size on SQL server ?