How to monitor DB backup failure using NCPA wizard

[swarna1986]

Hello All,

I need help for monitoring the following in Nagios XI tool using NCPA wizard.

• Data file full
• Tempdb full
• Blocking
• Deadlock
• Job failure
• DB Backup failure
• Backup device failure
• DB Restore failure
• Always On Availability Group status
• New database creation
• Database offline/suspect/recovery/restoring mode
• Login failure
• User account lock/expiry
• Average Lock wait time

DB Instance level Monitoring

• All the cluster/Always On Nodes are active/healthy
• SQL Server Browser
• SQL Full-text Filter Daemon Launcher

Thanks and Regards
Swarna

[scottwilkerson]

We have several database wizards that can monitor many of these, which have you tried? (not sure that the NCPA wizard is the best option)

[swarna1986]

Hello Scott

Thanks for your reply

Could you please tell me what all wizards can be used for DB monitoring in detail.

[scottwilkerson]

If you click
Configure -> Configuration Wizards
There is a database icon (5th from the left), click that and all the database wizards will appear