SQL 2000 Database

mcclelland2007 · Post by **mcclelland2007** » Wed Apr 11, 2007 1:46 pm

I set up HostMonitor to log to a SQL database last month. I had the default logging mode to full. I currently have 72 tests with that monitor our servers and applications every second to every minute. Since starting the monitor process, our SQL database has grown to over 15GB in size. I realize that logging every single change in every single test will cause this, but it is causing some hard drive space issues (as you can imagine). My question is this:

Is there a way to remove items from the database that are older than xx/xx/xxx and still be able to run reports on that date range?

KS-Soft · Post by **KS-Soft** » Wed Apr 11, 2007 2:06 pm

If you remove data, how Log Analyzer will be able to create reports?
I think you should create reports that you need, store report files, then remove old records

Regards
Alex

KS-Soft · Post by **KS-Soft** » Thu Apr 12, 2007 4:56 pm

BTW We plan to create utility that will pack log files/ODBC tables: it will calculate min/max/average reply, dead/alive time on hourly/daily/weekly basis, store these "hourly/daily" records and then remove processed log records.
May be this utility will be included in version 7.00

On the other hand, probably you may use "Reply" or "Midnight" logging mode instead of "Full" logging?

Regards
Alex