Kevin Holman's System Center Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of UseAre you interested in having a dedicated engineer that will be your Mic

Browse by Tags

Related Posts
  • Blog Post: Outages and Maintenance Report

    This is a little report I put together on request. This report will query the data warehouse, and show all the outages, and maintenance, for objects in specific groups. The outages look at all the “Failed to Connect to Computer” alerts, and list the start and end time of the outage, based on the...
  • Blog Post: MOM 2005 SP1 - upgrading SQL server from 2000 to 2005

      Upgrading from SQL 2000 to SQL 2005 to support MOM 2005 SP1: 1. Backup your MOM SQL server databases (OnePoint and Systemcenterreporting). Backup your Microsoft SQL Server Reporting Services databases. 2. Backup the SRS encryption key. 3. Stop the MOM Service on all management servers. 4. Upgrade...
  • Blog Post: Useful Operations Manager 2007 SQL queries

    Last updated 10-12-10     Large Table query .   (I am putting this at the top, because I use it so much – to find out what is taking up so much space in the OpsDB or DW) SELECT TOP 1000 a2.name AS [tablename], (a1.reserved + ISNULL(a4.reserved,0))* 8 AS reserved, a1.rows as row_count,...
  • Blog Post: How to find a specific rule/monitor/discovery in the console – when all you have a more cryptic ID in an alert

    Sometimes – we will get a Script Error alert, or WMI failure Alert, or some generic alert, telling us that some OTHER workflow had a problem.  These alerts are NOT the root cause… the root cause is the workflow that gets referenced in the alert.  The problem is – the alert often gives us a...
  • Blog Post: Useful MOM 2005 SQL queries

    SCDW/DTS:   Primary 6 tables that SCDW data is retained in: SC_AlertFact_Table SC_AlertHistoryFact_Table SC_AlertToEventFact_Table SC_EventFact_Table SC_EventParameterFact_Table SC_SampledNumericDataFact_Table Commands to execute to modify the data retention age:  Please run these commands...
  • Blog Post: Tuning tip: Do you have monitors constantly “flip flopping” ?

      This is something I see in almost all clients when we perform a PFE Health Check.  The customer will have lots of data being inserted into the OpsDB from agents, about monitors that are constantly changing state.  This can have a very negative effect on overall performance of the database...
  • Blog Post: Which servers are DOWN in my company, and which just have a heartbeat failure, RIGHT NOW?

              In OpsMgr 2007, when a agent experiences a heartbeat failure, several things happen.  There are diagnostics, and possibly recoveries that are run.  Alerts, and possibly notifications go out. But what happens if my Operations team misses on of these alerts...
  • Blog Post: Writing reports against RAW Perf data in the Data Warehouse

    By default – our generic reports access *aggregated* data in the warehouse… either daily or hourly.  These contain information like number of data points, avg, min, max, and std. deviation data.  However, sometimes users will want access to the RAW, individual data points. This is kept in the...