KAPes musings !

Archive for the ‘Monitoring’ Category

Lots of VERY useful SQL queries for MOM 2005

Posted by kapes on September 2, 2009


  • Queries to find out how old present data
  • Grooming the SCDW
  • Query to examine the last groom job and how long it took in the SCDW
  • Running the DTS job with latency
  • Faking the Onepoint database to think DTS is working in order to groom
  • Most common alerts in a Onepoint DB
  • To determine computers that are generating the most event data
  • To display the most common perf insertions

You get the idea 🙂


Posted in MOM-2005, Programming, SQL-Query | Tagged: , | Leave a Comment »