how to monitor all table growths
mkollu
Posts: 1 New member
for a single table we can add custom metrics , but i am looking for all tables in all db's the reason is our application will create tables and drop it
Tagged:
Answers
By default, SQL Monitor will not show metrics for each individual table or for all tables in a database. As you know already, there is a custom metric for a single table, further information here.
However, you will most likely need to create your own metric to monitor growth on all tables in a database. Best place to start will be the sqlmonitormetrics web site and how to write a metric.
I recommend you test it out by monitoring on a test database first.
If you wish to submit a feature suggestion for SQL Monitor to add this feature to a future version of SQL Monitor, please submit the suggestion here.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com