DB Size

Managing the size of your Remedy DB is often hard and understanding where the size in your DB is being taken is often harder, with data being stored in T, S, H, B, and BC tables it’s often hard to correlate that information back to Form names.  This tool is designed to provide an easy to use GUI method to get at this information.  It works in both MS SQL and Oracle and provides row counts and sizes for all of the tables associated with a form and provides an easy method to export this data to csv for convenient historical reference

Release History

2.2 – August 29, 2020

  • Added the name of the server that the list was retrieved from into the status bar
  • Updated the Oracle SQL to include tablespace_name and owner to try and limit the queries to ‘this’ remedy’s db…had a customer with multiple remedy in the same instance and previous versions were showing confusing results

2.1 – April 7, 2020

  • Modified the arschema code to be a DB query instead of a Remedy query, in case the user has a Remedy system old enough that the metadata tables don’t exist

2.0 – March 30, 2020

  • In Remedy 19.02 there was a new feature added for Row Level Security named ‘SubQuery’, this option creates a new S table (to go along with existing T/H/B, this update provides counts and sizes for those tables now too

1.0 – October 6, 2018

  • Initial Release