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 ...
Feature to take the trace of the highest CPU utilization process by the customer himself
Ramping up autoaggr statistics
GMU Migration - Ilegal Key size
getting 400 BAD request error for SP initiated federation
[Quick question] - How to check the DB size on SQL server ?