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 ...
Allow variables in :INCLUDE statements
Unix agent shut down with bind error
Delegated Administration process and procedures
Flexible SSH test step
User Administrators responsibilities and functions
[Quick question] - How to check the DB size on SQL server ?