KAPes musings !

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 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: