Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [alerts]

84 questions
10
votes
1 answer

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 notification email to the operator and it worked and we…
Sajid
  • 310
  • 1
  • 2
  • 11
8
votes
9 answers

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 failed. The Windows error code indicates the cause of…
SqlNovice
  • 654
  • 3
  • 13
  • 21
6
votes
3 answers

What are some important security-related error codes / events to monitor?

I am setting up alerts in SQL Server and am interested in what events I should be raising alerts for. In particular, I am looking for any events related to security. I am already monitoring error 18456.
derivation
  • 163
  • 6
6
votes
1 answer

"Replication Oplog Window has gone below 1 hours"

I'm working with MongoDB Atlas and I have a 3 node M30 cluster with 100GB of storage. My current use case is the following: A user dispatches one search in my platform The platform dispatches this search to other providers (12) I get like 2k…
Tzn
  • 103
  • 1
  • 1
  • 7
6
votes
2 answers

How do I create a SQL Agent Alert on a custom error message in SQL Server 2012?

I want operators to be notified when I throw a custom error message. My understanding is that I need to add a message to sys.messages, then I can either RAISERROR or THROW that error ID. Creating an alert on the message ID and setting it to send to…
Dan Bowling
  • 175
  • 1
  • 7
5
votes
3 answers

Create job to send alert using sp_send_dbmail when table value greater than x

PROBLEM The SMScounter.Counter is used to accumulate usage from a service. The service has a programmatic cap of 1000. I would like to alert users when this cap is breached. TABLE CREATE CREATE TABLE [dbo].[SMSCounter]( [Counter] [int] NOT NULL, …
scott_lotus
  • 287
  • 2
  • 6
  • 16
5
votes
4 answers

Recommendation for free event monitoring software

I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough. There are some interesting suggestions in this article and the subsequent comments, but before I set…
Eric Higgins
  • 2,689
  • 1
  • 19
  • 25
4
votes
2 answers

Alert when Job isn't triggered

I have a Sql Job on my server that is triggered nightly from a remote server (once it has completed its backups). I have successfully configured the job to notify me when it fails, but I would like to set up an alert to notify me when a job has not…
Obsidian Phoenix
  • 443
  • 5
  • 18
4
votes
1 answer

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 around the 100 character limit by altering…
jack
  • 419
  • 3
  • 8
  • 18
4
votes
1 answer

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. Please also give answer without event…
user129291
4
votes
1 answer

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(*) ---------- 1 Everything is now back to normal but one…
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178
4
votes
1 answer

How to find High CPU queries

CPU utilization is very high and the SQL Server process is consuming a lot of CPU. We have run few queries and notice that there are a few SPIDs taking a long time to complete and these queries may be causing the high CPU pressure. Is there any way…
Narendra
  • 165
  • 1
  • 10
4
votes
1 answer

Why is deadlock alert not working?

I created a deadlock alert including notification to an operator like this: EXEC msdb.dbo.sp_add_alert @name=N'1205 Deadlock', @message_id=1205, @severity=0, @enabled=1, @delay_between_responses=30, …
Magier
  • 4,827
  • 8
  • 48
  • 91
3
votes
1 answer

How can I create notification on user's connecting to database?

I have users that have access to several databases. I used to have an alert and notification sent to me when a specific user connects to a specific database, but I accidentally clobbered it. Now I have to recreate it. If I understand correctly,…
Sergey
  • 31
  • 2
3
votes
1 answer

Turn Off Alerts

We have a SQL Server 2008 R2 database instance running on a VM. Nightly, between 10p and 12a, we are getting the following error message: DATE/TIME: 2/3/2014 10:16:37 PM DESCRIPTION: Database mirroring connection error 4 '64(The specified…
petemill66
  • 159
  • 1
  • 9
1
2 3 4 5 6