Database Size Monitoring in 6.5?

[Derrick Hastie]

In SQL Server 6.5 what can you use to monitor the size of you database?

I know you can use the SQLPerfMon counters to constantly check the percentage of the log spaced used, I was just hoping there was a similar counter for the database size because I want to generate a system event when the database gets 80% full. Is there such a utility??

[Tom Willetts]

There arent any utilities that I am aware of, however I have written my own procedures which run using the task scheduler, write the results out to various tables in a monitoring database, and also generate mail messages when thresholds are exceeded. If you are interested I may be able to send you copies of the scripts.

Tom W


------------
Derrick Hastie at 9/6/99 7:19:45 AM


In SQL Server 6.5 what can you use to monitor the size of you database?

I know you can use the SQLPerfMon counters to constantly check the percentage of the log spaced used, I was just hoping there was a similar counter for the database size because I want to generate a system event when the database gets 80% full. Is there such a utility??