Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » OpsMgr - SQL   (RSS)
Sunday, August 30, 2009 6:21 AM

OpsMgr Agent Discovery Hanging after Enabling Broker Service?

When OpsMgr discovery hangs it’s because the SQL Broker service has not been enabled in the operationsmanager database.  Just a quick BING search will show you tons of hits about this issue – and I’ve never seen one case where this wasn’t the case
Posted by steverac | 0 Comments
Tuesday, June 09, 2009 2:34 AM

Using a variable to query TOP N entries from SQL

I was recently building a SQL query for use in a report and was looking for a way to return the ''top N’ results from a table matching my query criteria.  No big deal, right?  We do this all the time with a simple statement similar to Select
Posted by steverac | 0 Comments
Tuesday, June 09, 2009 12:25 AM

LocalizedText issues gone in R2?

Routine maintenance to keep the LocalizedText table trim has been a part of the OpsMgr administrators world for a while now. We have had a standardized query to clean this table that is posted on many blogs around the community – Kevin has a good article
Posted by steverac | 0 Comments
Filed under:

Attachment(s): LocalizedTextCleanup-supplemental.txt
Sunday, May 31, 2009 7:58 AM

OpsMgr DB Grooming – How it works

A while back I wrote up a blog post on how grooming works for the OpsMgr DB and the warehouse http://blogs.msdn.com/steverac/archive/2007/12/13/scom-2007-operational-and-datawarehouse-grooming.aspx Recently I put the detailed grooming steps for the OpsMgr
Posted by steverac | 3 Comments
Filed under:
Sunday, May 24, 2009 7:40 AM

Large table query, with rowcount

Kevin has a number of very helpful queries on his blog – posted here .  One of the most commonly used is the large table query.  The large table query returns the space consumed by the table in kb, the space consumed by the index in kb and the
Posted by steverac | 1 Comments
Filed under:
Saturday, April 19, 2008 11:32 PM

Required SQL Maintenance for OpsMgr

My collegue, Kevin Holman, has a blog post with great discussion about SQL maintenance for OpsMgr databases. Take a look. http://blogs.technet.com/kevinholman/archive/2008/04/12/what-sql-maintenance-should-i-perform-on-my-opsmgr-databases.aspx Steve
Posted by steverac | 1 Comments
Filed under:
Monday, January 07, 2008 7:38 AM

A few opsmgr questions of interest - Question 7

1. How does reindexing work in opsmgr? Is it a SQL job? Which one? Is it a rule in the SQL management pack? Which one? Document how all the built in maintenance works in the operational and reporting database and why we don’t need and shouldn’t setup
Posted by steverac | 0 Comments
Filed under:
Thursday, December 13, 2007 11:24 PM

SCOM 2007 - operational and datawarehouse grooming

The mechanism for grooming the operational database in SCOM has changed compared to MOM 2005. In MOM 2005 we had a SQL job to handle the grooming – in SCOM 2007 we have a SCOM rule. The rule has a set schedule to run daily at midnight – and there is no
Posted by steverac | 12 Comments
Filed under:
 
Page view tracker