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