Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » OpsMgr - SQL   (RSS)
Sorry, but there are no more tags available to filter with.

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:

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:

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 | 2 Comments
Filed under:
 
Page view tracker