Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

Thursday, October 01, 2009 6:39 AM

Noisy DBCC Rule in the SQL Management Pack

The SQL Server Management Pack has a rule, targeted at SQL 2000/2005/2008 DB Engine named “DBCC executed found and repaired errors”.  This rule monitors for Event ID 8957 in the Application Log, logged by the SQL Service.  Here is the criteria
Posted by jimmyharper | 0 Comments
Filed under: , ,
Thursday, October 01, 2009 5:19 AM

Using Integers and other “non-string” data types in Rules and Monitors

If you need to use any non-string data type in the criteria for custom Rules and Monitors, you’ll need to edit the XML in order for it to work properly.  By default, OpsMgr will treat everything as a String value and the Rule/Monitor will not work
Posted by jimmyharper | 0 Comments
Filed under: , ,
Saturday, September 26, 2009 7:04 AM

Overrides view in R2

Here’s one of many good uses of the new Overrides view in OpsMgr 2007 R2.   I want to review overrides that I have set for Rules and Monitor that target the SQL 2005 DB and SQL 2005 DB Engine classes.  I’m mostly interested in Overrides that
Posted by jimmyharper | 0 Comments
Filed under: ,
Saturday, September 26, 2009 6:30 AM

Exchange 2007 Synthetic Transactions against clustered Mailbox Servers may stop working

Are you using the new Exchange 2007 Management Pack? Are you configuring the CAS and/or Mailflow synthetic transcactions? Are any of your target Mailbox servers clustered? If so, then you’ll want to verify that these transactions are actually running…and
Posted by jimmyharper | 0 Comments
Tuesday, August 25, 2009 6:15 PM

Health Service problem on Windows 2000 Agent

I recently ran into an interesting issue with a customer.  A Windows 2000 Agent (running OpsMgr SP1) was not able to process configuration due to problems creating/using the self-signed certificate that the Health Service uses (this is not a Gateway
Posted by jimmyharper | 5 Comments
Wednesday, August 12, 2009 12:00 AM

Service Monitors – What does the “State” value mean?

When you create a Service Monitor in OpsMgr 2007, we get an alert / state change when the service is not running, but this does not necessarily mean that the service is “stopped”.  The monitor attempts to get the “State” of the service, and alerts
Posted by jimmyharper | 0 Comments
Filed under: ,
Thursday, July 02, 2009 8:41 AM

SQL Server Full Text Search Service Monitor

This issue is described in the SQL Server Management Pack Guide, but I wanted to blog it since I’ve seen a couple customers hit it. In the current version of the SQL Server Management Pack (version 6.0.6559.0), we have a monitor for the SQL Server Full
Posted by jimmyharper | 3 Comments
Attachment(s): Full.Text.Search.Service.Monitor.Groups.and.Overrides.zip
Thursday, June 11, 2009 6:26 PM

SQL Database Properties Not Discovered

I ran into an issue recently where some SQL Databases were not showing any properties in OpsMgr, other than the database name: To get these properties, the database discovery script runs the “sp_helpdb” stored procedure against the database. To test this,
Posted by jimmyharper | 0 Comments
Filed under: , , ,

Attachment(s): DB_Discovery_debug_scripts.zip
Friday, June 05, 2009 3:36 AM

SQL Agent Job Discovery not working?

The SQL Server Management Pack includes an option to discover and monitor SQL Server Agent Jobs for SQL 2000/2005/2008. The Discovery for this is disabled by default: I ran into an issue recently where all Agent Jobs for specific SQL Servers were not
Posted by jimmyharper | 4 Comments
Attachment(s): Custom_SQL_Agent_Job_Discovery.zip
Wednesday, May 20, 2009 7:33 AM

AD Trust Monitor doesn’t reset to Healthy State

The Active Directory Management Pack (ADMP) – version 6.0.6452.0 – contains a monitor named “AD Trust Monitoring”.  This monitor runs a VBScript which queries WMI to get the status of the Domain Trusts on the Domain Controller.  Is the trust
Posted by jimmyharper | 4 Comments
Wednesday, May 20, 2009 6:30 AM

Configuring or Disabling Replication Monitoring in the Active directory Management pack

The latest version of the Active Directory Management Pack (ADMP) – version 6.0.6452.0 – contains some significant changes to Replication Monitoring.  The basic premise is the same, but the Rules and Monitors used have changed a bit. Here’s a quick
Posted by jimmyharper | 5 Comments
Saturday, February 21, 2009 1:29 AM

AEM Views and tables

I'll soon be putting together some AEM (Agentless Exception Monitoring) reports, so I figured I'd familiarize myself with the how AEM data is stored in the Date Warehouse. Surprisingly, not all of the useful data is stored in Views....you have to go to
Posted by jimmyharper | 0 Comments
Saturday, February 21, 2009 1:16 AM

No Alert from SQL MP when clustered services go down

I recently ran into the following issue: The SQL Server Management Pack has several monitors to monitor various SQL Services: However, on a SQL Cluster, if one of these services is taken offline: We don't get an alert from SQL (we do get a cluster alert
Posted by jimmyharper | 14 Comments
Monday, February 16, 2009 3:18 AM

ACS report: All events for specified user (even more than the built-in version)

A customer recently showed me that the built-in ACS report "Forensic_-_All_Events_For_Specified_User" seemed to be missing some events. This report queries the Adtserver.dvall5 view in the OperationsManageAC database and looks for values in the PrimaryDomain\PrimaryUser
Posted by jimmyharper | 0 Comments
Filed under:

Attachment(s): ACS - ALL Events for Specified User-Queried Domain List.rdl
Monday, February 16, 2009 1:39 AM

Custom performance report with threshold line

I recently had a need to create an OpsMgr report to show performance data with a "threshold" line, so that it would be easy to see data points that went over a defined threshold. We can't do this with the built-in generic performance report, so I put
Posted by jimmyharper | 1 Comments
Filed under:

Attachment(s): Perf Chart with Threshold Line.rdl
More Posts Next page »
 
Page view tracker