SQL Monitoring Policy task is taking a very long time to run (many hours) (NETIQKB50100)

  • 7750100
  • 02-Feb-2007
  • 21-Apr-2011

Environment

NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

SQL Monitoring Policy task is failing.
Dynamic Views are not updating.
Monitoring Policy jobs are taking a very long time to go into running status.
Monitoring Policy does not automatically run jobs on computers added to a Server Group.
When I attempt to deploy any Monitoring Policies, the monitoring policy jobs are not created.
Inability to add or stop jobs in a monitoring policy.

Resolution

To temporarily improve performance of the Policy task, run the Monitoring Policy and Dynamic View stored procedures one at a time:

  1. Run SQL Query Analyzer.
  2. For the Monitoring Policy jobs, run:  exec db.UpholdMonitoringPolicy
  3. For the Dynamic Views, run:  exec dbo.UpholdDynamicViews

If you are using and older version of AM6 or AM7 you can improve performance by installing the latest AM hotfixes from https://www.netiq.com

Cause

Dynamic Views and Monitoring Policy jobs are processed by the SQL Monitoring Policy repository task.  If numerous Dynamic Views exist, or if the Dynamic Views have extensive rules associated with them, then the Monitoring Policy task may be bogged down with updating the Dynamic Views on each iteration of two minute intervals. The monitoring policy jobs and the dynamic views are not getting updated in a timely fashion.

Additional Information

Formerly known as NETIQKB50100