KAPes musings !

Archive for the ‘MOM-2005’ Category

Lots of VERY useful SQL queries for MOM 2005

Posted by kapes on September 2, 2009

http://blogs.technet.com/kevinholman/archive/2007/10/18/useful-mom-2005-sql-queries.aspx

  • 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 »