Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » TSQL   (RSS)
Friday, July 24, 2009 8:51 PM

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
Posted by kevinhol | 0 Comments
Filed under: ,
Thursday, June 11, 2009 5:48 AM

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
Posted by kevinhol | 9 Comments
Filed under: , ,

Attachment(s): Outage and Maintenance Report.zip
Friday, April 17, 2009 7:58 PM

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. 
Posted by kevinhol | 3 Comments
Filed under: ,
Friday, February 01, 2008 10:44 PM

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
Posted by kevinhol | 0 Comments
Filed under:
Thursday, October 18, 2007 7:44 PM

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
Posted by kevinhol | 2 Comments
Filed under: , ,
Thursday, October 18, 2007 7:35 PM

Useful Operations Manager 2007 SQL queries

Last updated 11-9-09     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 so.name, 8 * Sum(CASE WHEN si.indid IN (0, 1) THEN si.reserved
Posted by kevinhol | 26 Comments
Filed under: ,
 
Page view tracker