Page 1 of 1

How to monitor DB backup failure using NCPA wizard

Posted: Fri Sep 04, 2020 3:32 am
by 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

Re: How to monitor DB backup failure using NCPA wizard

Posted: Fri Sep 04, 2020 3:58 pm
by 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)

Re: How to monitor DB backup failure using NCPA wizard

Posted: Sat Sep 05, 2020 12:16 am
by swarna1986
Hello Scott

Thanks for your reply

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

Re: How to monitor DB backup failure using NCPA wizard

Posted: Tue Sep 08, 2020 7:33 am
by 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