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? |
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers. 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) sp_spaceused (Transact-SQL) 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. Link: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-spaceused-transact-sql?view=sql-server-2017 Alternatively, run Disk Usage by Top Tables report from within SQL Server Management Studio |