I have been gathering stats over 700+ servers for 3-4 months and the database has grown to 75GB. I'm looking to tidy up the database and only have 1 month on-line. I know this should have been done at the start.
When I try and run a script to delete entries before a date it does delete but very very slow. Any help on tuning the database would be great.
Many Thanks Barry
|