Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Disable hardware health monitoring manually

Disable hardware health monitoring manually

Updated June 25, 2018

Overview

This article describes how to disable Hardware Health monitoring for a server if, for example, the server moved from a physical to a virtual environment. The Orion Web Console continues to display hardware data for virtual servers as N/A or Undefined in various widgets (formerly called resources), and there is no option in SAM to disable polling hardware health for a node.

Environment

All SAM versions

VMware

Resolution

Although you cannot disable hardware monitoring for a node in the Orion Web Console, you can do it directly in the database by setting the IsDisabled column to 1 in the APM_HardwareInfo table. 

You must have Node Management rights to perform this workaround.

To disable hardware monitoring for a node, use the following SQL script:

UPDATE APM_HardwareInfo SET IsDisabled = 1 WHERE NodeID = InsertNodeIdHere

After you execute the script, the polling job for the node is removed within 30 seconds. When the Orion Web Console refreshes (by default, every five minutes), hardware-related resources and statistics disappear from the Node Details page.

To delete hardware-related health data from the Orion database for a specific note, use the following SQL script: 

DECLARE @NodeID int
SET @NodeID = _InsertNodeIdHere_
DELETE FROM APM_HardwareInfo WHERE NodeID = @NodeID
DELETE FROM APM_HardwareCategoryStatus WHERE NodeID = @NodeID
DELETE FROM APM_HardwareItem WHERE NodeID = @NodeID

To delete orphaned historical data for sensors, run this command:

EXEC apm_dbm_APM_HardwareItemStatistics_DeleteOrphans

 

For reference, see:

Last modified

Tags

Classifications

Public