Questions tagged [alerts]

The tag has no usage guidance.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
586 views

SQL Server Event Alerts Lack Enough Details

I setup SQL Server Alerts to send me emails whenever certain events (by severity) occur. Below is an example of en email I received for a "014 - Insufficient Permission" severity event of Type "SQL ...
2
votes
0answers
274 views

WMI event alerts

I am trying to understand WMI event alerts and have implemented a mirror with alerts on DATABASE_MIRRORING_STATE_CHANGE such that all database failover if the state is either 7 or 8 (manual failover ...
1
vote
0answers
32 views

queries to active live test health of a galera cluster

What queries could be used to foresee or better fine tune alerts to check the health status of a Galera (MariaDB) cluster? The problem I am facing is that randomly the cluster gest stalled because of ...
1
vote
0answers
145 views

SQL Server Agent Alert does not pick up some of Events from Application Log written by SQL Server Audit

My end goal is to be emailed when new object (schema, table, procedure etc.) is created / altered / dropped at one of my databases on SQL Server I created a server-level audit, that writes to Windows ...
1
vote
0answers
1k views

SQL Server Alert System: 'Severity 17 - Potentially Fatal Error Insufficient Resources' occurred on myserver

I get a alert email with the title: SQL Server Alert System: 'Severity 17 - Potentially Fatal Error Insufficient Resources' occurred on myserver as 12:02 when I connect to myserver to check the ...
1
vote
0answers
14k views

ORA-03137: TTC protocol internal error

I have 11g 2-node RAC. My alert.log contains several ORA-03137 errors: Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_10679.trc (incident=149362): ORA-03137: TTC protocol ...
1
vote
0answers
167 views

Setting up replication alerts

I 'm trying to configure alerts for replication. Currently on my test setup I run everything under user 'sa'. When I try to set up alert for agent failure I get the following error Login failed for ...
0
votes
0answers
29 views

Combine multiple alerts in to single alert

I'm trying to find a way to generate a single alert by combining multiple alerts for AlwaysOn setup (for example error codes- 1480 , 19406) which gets logged in SQLERRORLOG file during planned or ...
0
votes
1answer
128 views

SQL agent job for long running queries

I am trying to setup an alert where the application team can get the notification on their event viewer for any queries which are running longer than 2 minutes. This is what I have so far. For some ...
0
votes
0answers
20 views

Alert message to remote SQL DB form local SQL DB if no data from software application

I am looking for a solution for my software application which has local SQL DB for data storage and from the local SQL DB replicate the data in real time to a remote SQL DB for visualizing the data in ...
0
votes
0answers
55 views

Setting precedence of MS SQL Agent alerts

I've recently encountered an issue with a SQL system I've inherited. Agent alerts have been configured to trigger on Severity and on Error ID. However, it seems like a given error can only trigger a ...
0
votes
0answers
2k views

A read operation on a large object failed while sending data to the client

A few days ago, in one of my servers, I had the following alert pop out: A read operation on a large object failed while sending data to the client. A common cause for this is if the application ...
0
votes
0answers
642 views

Why was a “default trace stopped due to not enough space on the disk” Alert email not sent until 3 days after the event?

SQL Server 2008 R2 instance sent a Severity 016 Alert: "Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the ...
0
votes
0answers
696 views

Enterprise Manager goes pink, legend color for other

To whom it may respond to, While monitoring our databases, we have seen that one of EM screens has gone pink, the color stands for OTHER at the legend. We have checked alert log and trc files, ...
0
votes
0answers
528 views

ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7

Oracle version is : 11.2.0.1 I have created alerting on every error occurring in database, and in this alert log I've found the following errors ORA-13901: Object UNDOTBS01 was not found. ORA-06512: ...
0
votes
0answers
2k views

How to display Oracle Enterprise Manager 11g (OEM) alerts and reports in Nagios?

I am working on a project that requires an unobtrusive integration of OEM data into a Nagios front-end. I know there are ways to use SNMP traps to do this, but I am not completely familiar with how ...