Want to replicate DB table sizes to server

nav_dell

Hi,
We have many clients on our network running 3.60 proprietary attain db. Our server is running SQL.

I have been thinking about how to replicate table sizes to HO to monitor. In my research I have seen the table information table has all this info but I'm not sure the best way to go about completing the goal.

At the moment I'm thinking - Create a new table on each client and automatically write the table information data into this new table once a day where the all the rows in the table will get their sizes added up and written into a third column in the same table. This third column would only ever have one record.

Firstly I don't know how to copy this data automatically into my new table and I don't know how to calculate the quantity of all the lines summed and write it into the third column.

Perhaps someone can give me some pointers or suggest a better solution.

I look forward to a response - thank you.

bbrown

Train your clients how to monitor/manage their own databases.