Question : I’m working with MongoDB Atlas and I have a cluster of 3 with M30 and 100gb of storage. […]
Tag: alerts
SQL Server Alerts on VMs
Question : Newbie here.. Hello Searching online and I could not find any articles/blogs that pointed, related or had any […]
Does the @raise_snmp_trap do anything in @sp_add_alert?
Question : I have a request from a client to incorporate SNMP Traps as the method for alerting in SQL […]
How to configure DB server space alert step by step [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Change character limit of SQL Agent Operators
Question : I want to add more than 100 characters worth of email addresses to the SQL Agent Operators alerting. […]
Way to test alerts for backups?
Question : We have some SQL Servers that are backed up using T-SQL and some that are using 3rd party […]
Retrieve alert error description text via SQL Server Agent
Question : We have configured Alerts for the major severities and error codes on our SQL Server instances. Each alert […]
Create job to send alert using sp_send_dbmail when table value greater than x
Question : PROBLEM The SMScounter.Counter is used to accumulate usage from a service. The service has a programmatic cap of […]
Why is deadlock alert not working?
Question : 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, […]
How can I create a brand new alarm based on a verification not listed by default on SQL Server?
Question : I want to create an alert like the ones from Brent Ozar’s How to Configure SQL Server Agent […]