Test remote SQL connectivity EASILY!

I learned about something very useful today and thought I’d share. Have you ever been troubleshooting a problem with remote SQL Iproxy MP, remote DB, etc) and wanted to test to see if the local system account (or any account for that matter) could make a remote connection to SQL but you didn’t want to…


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 – until now. I just finished working an issue where OpsMgr…


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 TOP 10 <what you want to display>…


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 on the required cleanup posted here. I recently came…


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 DB into a graphical form that I share here.  Please note – even though there are specific tables shown here don’t consider this posting…


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 space consumed by the blob in kb. …


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


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 our own standard maintenance jobs.   The mechanism…


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 built in override…