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 ...
DATA GUARD failover affected AE
CA World '18: Call for Speakers Now Open
Parent Role Useful?
Role Based forecasting & Hard Booking resources
Cancel a job if it is in the Waiting for host status
[Quick question] - How to check the DB size on SQL server ?