This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Remedy AR System Server v8.x, v9.x
I want to monitor the growth of data in my AR System. How can I get a count of the number of records in each form so I can see which ones are huge and which ones are growing?
Attached are two database scripts, one for SQL Server and one for Oracle.
These scripts can be run from a database prompt or query window to get a list of the forms and how many records they contain.
The list is sorted by the number of records, with the highest being on top
The results look like this example below:
For SQL Server only (not applicable for Oracle)
Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.
Alternatively, run Disk Usage by Top Tables report from within SQL Server Management Studio