Questions tagged [alerts]
The alerts tag has no usage guidance.
82
questions
0
votes
0
answers
76
views
Alert Failover AG
I put the alert 1480 for the notification of the Failover AG
I need to add in the notification the primary replica and the secondary replica
Do you have an idea please?
EXEC msdb.dbo.sp_add_alert @...
1
vote
0
answers
115
views
Which SQL Server performance condition DB alert can be used to find "RESOURCE_SEMAPHORE" waits?
I'm trying 2 SQL Server Alerts:
SQL Server:Memory Manager / Memory Grants Pending / Waits in progress / rises above / Value: 5
SQL Server:wait Statistics / Memory grant queue waits / Waits in progress ...
- 81
1
vote
1
answer
18
views
What is the Rule of thumb for alerting on`mysql.innodb.buffer_pool_reads / mysql.innodb.buffer_pool_read_requests`?
Is there a rule of thumb for monitoring mysql.innodb.buffer_pool_reads / mysql.innodb.buffer_pool_read_requests?
I am using the following formula, but I'm starting to think it's too sensitive.
(mysql....
- 123
0
votes
0
answers
96
views
High CPU Usage Alert Not Working in SQL Server 2016 Standard Edition
I have configured database alert in SQL Server 2016 Standard Edition and trying to raise an alert when CPU usage goes above certain percent but the alert is not triggering.
The Alert is working for ...
0
votes
1
answer
143
views
SQL Server 2019 how can I create an alert for when service broker messages are aggregating in the queue and not being processed?
How do I create an alert in SQL Agent, to notify me once service broker message queue exceeds 300 messages? I am trying to get a notification to an operator in SQL Agent when this occurs.
- 37
1
vote
2
answers
53
views
How can I create a brand new alarm based on a verification not listed by default on SQL Server?
I want to create an alert like the ones from Brent Ozar's How to Configure SQL Server Agent Alerts, but I couldn't find a message related to the error I want to monitor on sys.messages as the ...
- 4,954
1
vote
1
answer
904
views
Error Severity 16 Alert being raised for events where is_event_logged = 0
I have an error level 16 alert set up as follows:
USE [msdb]
GO
EXEC msdb.dbo.sp_add_alert @name=N'Error - Severity 16',
@message_id=0,
@severity=16,
@enabled=1,
@...
- 1,809
0
votes
3
answers
245
views
How to set email alerts for high IO errors (sql server error log)?
The sql server error logs show multiple entries with the following keywords:
IO taking longer longer 15 seconds
I want to setup email alerts for these errors. I have email alerts configured for ...
- 3,153
0
votes
3
answers
10k
views
Oracle alertlog with WARNING: too many parse errors
The SQLID is not available. Any ideas on how to find the source of the problem?
9913 WARNING: too many parse errors, count=414884 SQL hash=0x896ff002
9914 PARSE ERROR: ospid=24108, error=6550 for ...
- 938
0
votes
1
answer
246
views
Is there a way to setup one Alert for all Replication errors?
I have a SQL Server 2016 (Standard) instance, with DatabaseA, who is the Publisher in a Transactional Replication (push subscription) topology. A second SQL Server 2016 (Standard) instance, with ...
- 30.6k
1
vote
2
answers
196
views
DBCC CHECKDB not sending an alert when Corruption Found for Severity Level 16
I have setup this alert that I got from Brent Ozar's Website.
EXEC msdb.dbo.sp_add_alert
@name=N'Severity 016',
@message_id=0,
@severity=16,
@enabled=1,
@delay_between_responses=60,
@...
- 11
0
votes
1
answer
236
views
How to monitor for MySQL select queries that return too many records? [closed]
I realize there are simple ways to limit results in SQL. I have a legacy implementation. I would like to get a handle on select queries that return results exceeding some user defined limit. The goal ...
- 101
0
votes
1
answer
388
views
Free Drive Space and SQL Server Agent Alerts
I need to receive an email when free drive space on E: or H: becomes less than 20%
I know that can be achieved by setting up a job that executes PowerShell or T-SQL scripts on a schedule, that checks ...
- 5,144
1
vote
1
answer
502
views
SQL Server Agent Alerts and Severity Errors
I've setup alerts in SQL Agent for errors of severity level 15-16 for testing, and found out that these are not always triggered
To be more exact, these seem to trigger only when given error number ...
- 5,144
4
votes
1
answer
11k
views
MongoDB - Replication Oplog Window has gone below 1 hours
I'm working with MongoDB Atlas and I have a cluster of 3 with M30 and 100gb of storage.
My current usecase is the following:
- An user dispatches one search in my platform
- The platform dispatches ...
- 83
-1
votes
1
answer
127
views
How to configure DB server space alert step by step [closed]
Could you please help me on the question.
Here is the requirement.
I have one server and there is 2 drives are available (C and D).
Due to mssql Log file growth E drive is always getting filled and ...
4
votes
1
answer
2k
views
Change character limit of SQL Agent Operators
I want to add more than 100 characters worth of email addresses to the SQL Agent Operators alerting.
For example: emaione@example.com;emailtwo@example.com;emailthree@example.com;....
I tried to get ...
- 359
2
votes
1
answer
315
views
Trigger SQL Agent job based on text in error log for an AG failover
I have a 2 node AG setup (Not an FCI). I need to configure an alert to trigger a job based on a string found in the error log showing that the node is now the new primary.
The string I want to use is:
...
- 253
-2
votes
1
answer
205
views
SQL Server Event Log Summary [closed]
I want to generate a daily summary of SQL Server Event Logs which will be sent via email. I have currently been able to set up SQL email alerts for error logs,but they are sent individualy when an ...
1
vote
0
answers
75
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 ...
- 149
1
vote
1
answer
1k
views
SQL Alert for long running queries [duplicate]
I want to receive a mail when a query is running for more than x seconds. I know I can set up a job running on the database but, is there any way to do the same using SQL Alerts? What kind of alert ...
- 31
0
votes
1
answer
511
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 ...
- 625
0
votes
0
answers
27
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 ...
2
votes
1
answer
301
views
how to set up sql server alerts based on a schedule basis?
We would like to stop getting sql server alerts from dev servers during the weekend. We have alerts for severity 016 to 025.
- 33
0
votes
1
answer
214
views
Retrieve alert error description text via SQL Server Agent
We have configured Alerts for the major severities and error codes on our SQL Server instances. Each alert then runs the same SQL Server Agent job, to trigger an alert in our monitoring system (for ...
- 535
0
votes
1
answer
85
views
Question about alerts in Oracle 11.2
I inherited an Oracle 11.2 server. I wanted to see if whomever configured it before me had any alerts configured, perhaps to notify on audit events.
Logging on as sysdba, I issued this command per ...
- 147
1
vote
0
answers
219
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 ...
- 5,144
1
vote
1
answer
132
views
How to get user name to appear in Alerts
Setting up some alerting in SQL server 2017 which get dispatched by email to certain DBAs.
Some examples of alerting I am trying to configure would be for Alert number 229 - The EXECUTE permission ...
- 273
2
votes
1
answer
299
views
Notification of row entries
I have SQL Server 2012 machine housing a database running an off the shelf application with a users table. This users table contains PII enterable fields. Per requirement none of our databases can ...
- 21
2
votes
3
answers
598
views
How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?
I have a database whose initial size is set to 1000 GB.
Is there a way where i can set an alert when the max space is used and database size is nearing to 1000 GB, for eg when it reaches maybe 995 or ...
- 103
2
votes
2
answers
10k
views
Getting “SQL Server Alert System: 'Alert Severity 20' occurred” error occasionally
We occasionally get following email alerts.
DESCRIPTION: The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the ...
- 327
-1
votes
1
answer
145
views
Job duration email
I have need to be able to generate two types of alerts:
We have a sql job which runs every 1 hour. I need an alert to let us know the time it took to complete the job
As the count for Table1 ...
- 77
1
vote
2
answers
2k
views
How do I automatically enable or disable report jobs at AOAG failover?
I have an AlwaysOn Availability Group with 2 DB servers. I'm attempting to use SQL Server Agent Alerts to programmatically disable a handful of SQL Server Agent jobs (that must not run on a secondary) ...
4
votes
1
answer
7k
views
DBA Blocking Query Email Alert
Does anyone have a good Sql Alert which sends email notifications, when query Blocking has occurred over many minutes?
I know how to write my own, however seems to be a good code library on internet.
...
user129291
0
votes
0
answers
81
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 ...
- 111
2
votes
1
answer
82
views
Setting Up SQL Alerts
I have turned on notifications via email on my SQL Server Agent if any of my scheduled jobs failed or is successful.
Can anyone help me if I want to set up Alerts, if in case one of the scheduled job ...
- 21
3
votes
1
answer
211
views
Does the @raise_snmp_trap do anything in @sp_add_alert?
I have a request from a client to incorporate SNMP Traps as the method for alerting in SQL Server. The only way I have found to do this is by using [dbo].[sp_add_alert] found in the [msdb] database.
-...
- 235
1
vote
1
answer
85
views
How to know exactly when my Database / Log files grew?
Is there a way to see when (history / log records) of .mdf / .ldf files grew?
Ultimately, is it possible to setup alerting and know immediately when my database / log files grow?
- 5,144
7
votes
6
answers
50k
views
SSPI handshake failed with error code 0x8009030c, state 14
DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext ...
- 644
0
votes
1
answer
40
views
With foreign keys automagically dropping out, can I set up an alert?
A strange thing happened to my company's Oracle database:
Foreign key constraints keep dropping out by themselves.
If you could solve this problem, that would be great. But even if you can't, ...
- 131
1
vote
2
answers
2k
views
SQL Job is getting failed randomly while trying to send the alert email. need help
We have configured a alert which triggers the email using a job. But the job fails randomly during the day and we don't receive the alert related mails. If I clear the ExternalmailQueue it starts ...
- 31
0
votes
2
answers
3k
views
Need to setup a sql alert on "waiting tasks" - similar to "waiting tasks" in Activity Monitor
My manager has asked me to work upon a request. I am not sure if it is reasonable or weird but he wants me to setup an alert based on the "waiting task" that we see in the activity monitor. Basically, ...
- 507
3
votes
3
answers
2k
views
Cpu% usage alert is not working for 'alert if counter=raises above'
I am thinking to create an alert for Cpu usage when it crosses certain value. So i configured one alert for this and attached those screen shots here
But the above alert is not working mail is not ...
7
votes
1
answer
7k
views
SQL Server alerts not sending notification emails to the operator
I have setup few SQL Server alerts and added Operator to notify if any alert occurred.
I just noticed that couple of alerts did occurred but we didn't receive any alert email. I did send a test ...
- 180
2
votes
1
answer
2k
views
How to script alerts in SQL Server?
after trying out this script: Script out all alerts By Carolyn Richardson
or even the traditional way of ssms -> right click -> script alert as
none of these methods are fully comprehensive because ...
- 15.5k
1
vote
0
answers
4k
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 ...
- 15.5k
0
votes
1
answer
129
views
Setup mail notifications on SQL Server (severe) errors
I want to be notified by email whenever an error occurs on our production database (e.g. failed database backups, engine crashes due to corruption etc). I could not find built-in support for this, so ...
- 101
0
votes
1
answer
778
views
Monitor and alerting tool for specific queries [closed]
I need to monitor and alert a MySQL DB which is hosted on AWS. I'd like an alert to trigger if certain SQL query criteria aren't met (e.g. SELECT * FROM my_table returns less than 100 results).
What ...
- 7
0
votes
1
answer
431
views
Can I create alert on ora-20118 from Enterprise Manager?
Can I create an alert on a user-defined ORA- error?
I want EM to notify me when the following error happens:
begin
raise_application_error(-20118, 'myerror');
end;
/
- 1,707
4
votes
1
answer
825
views
What is preventing ORA-00376 errors appearing in the alert log?
An overnight hard drive failure had various side-effects, including leaving a single datafile needing recovery:
SQL> select count(*) from v$datafile where status='RECOVER';
COUNT(*)
----------
...
- 38.7k