Post reply

SQL and MOM

  • July 18, 2006 at 9:22 am

    #68332

    We have MOM running in test mode on SQL2000. The db has grown to 12Gb with 1 log file of 2Gb. We have used MOM grooming but seems to have no effect. What is the best way to delete the records from the Eventparam tables?

  • July 19, 2006 at 10:07 am

    #650156

    Which database OnePoint or is it the SystemCenterReporting database ? If it's OnePoint then depending on your monitoring, the number of servers, etc. it could grow to 20-30 Gb. If it's the SystemCenterReporting database then 200-300 Gb is not unusual.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply