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.
[Quick question] - How to check the DB size on SQL server ?
Discussion created by
on Sep 29, 2017
on Jan 3, 2018 by Pascal_Osthus-bugat_1753
Show 0 Likes
please find below a request to check the size of your DB on SQL Server. It could be useful to provide this information to the support in case of performance issue, for example.
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Jan 3, 2018 2:13 PM
A simple example how to use these procedure to check the size of the database could be:
For example if we execute this procedure on the high activity tables AH, RH, RT and OH we would obtain the following output.
An other way to do is described in this post here. Using this stored procedure you will be able to obtain information about all One Automation tables on SQL Server
Show 0 Likes
Retrieving data ...
Raise a concern for open support case
Agent Group / Oracle E-Business Suite
SMTP mail server issue in Emailgtw Probe
Community Hack - Find Your Product Community
Hello, I am registered with CA Support for Site ID ****** - Department for Works and Pensions' (Email Address: JAMES.TYLER2@DWP.GSI.GOV.UK)