Automic Workload Automation

  • Private Community
Back to discussions
Expand all | Collapse all

[Quick question] - How to check the DB size on SQL server ?

  • 1.  [Quick question] - How to check the DB size on SQL server ?

    Posted Sep 29, 2017 06:07 AM
    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.
     

    exec sp_spaceused



  • 2.  [Quick question] - How to check the DB size on SQL server ?

    Posted Jan 03, 2018 09:13 AM
    A simple example how to use these procedure to check the size of the database could be:

    exec sp_spaceused 'table_name'


    For example if we execute this procedure on the high activity tables AH, RH, RT and OH we would obtain the following output.

    jvxlc54btgub.pnghttps://us.v-cdn.net/5019921/uploads/editor/u6/jvxlc54btgub.png" width="419">

    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 here.