Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How to monitor SQL error with severity > 16

sannatar

Anyone monitoring SQL errors with severity > 16 . It would be a great help, if anyone could share the details.

Thanks..

@aLTeReGo

Find more posts tagged with

sql

PowerShell

Accepted answers

aLTeReGo

SQL writes everything that is contained within the error log to the Windows Event Log. That is where I would recommend monitoring for those events. 'How' would be using theWindows Event Log Monitor' in Server & Application Monitor. This allows you to target specific severities, include or exclude a list of EventIDs, etc. It's really quite powerful.

All comments

jm_sysadmin

I am not, but how would you do it manually? Maybe we can work through it.

aLTeReGo

sannatar

This is one of the way we can achieve , But we are not sure how many event id's to be added for the component, The existing monitoring tool has the capability to directly monitor through the severity level(16-24), so We haven't gone through the event id wise, But let me put this to our DBA. Thanks @aLTeReGo