We are not receiving the alerts when windows reboot , how to get the alerts when Windows SQL server reboot.
SQLDM isn't really designed as a Windows monitoring tool. As such, there isn't a metric that's built-in that specifically checks when the server was rebooted.
However, you could potentially make use of the Custom Counter feature. You could potentially create a T-SQL script that queries the instance to see when the instance was last restarted and compare the timestamp to the current time. Another option would be to create a custom counter based on a WMI counter. I suspect there ought to be some WMI counter that's related to the last server boot up timestamp.
Hope that helps!
Thanks for Suggestion, i am creating the new custom counter for this alerts, when I am creating the custom, i am getting confusing while selecting the warning and critical values since I need to receive alert when server SQL reboot time less than 5-10 minutes (select DATEDIFF(MINUTE,create_date, GETDATE()) as Reboottime from sys.databases where name='tempdb'). can you please help me set those values.
When you configure the custom counter, I would probably select the Lower values are worse than higher values option. For the threshold settings, I would probably set Critical at 10 (for 10 minutes) and higher values for information and warning, then save the custom counter.
Once you have the custom counter created, link it to your monitored instances or even an alert template. If you don't care about warning or information statuses, you can then go configure the alert thresholds for the instances that you applied the custom counter to and disable the warning and information statuses.
I hope that helps.
Thanks, i have created the custom counter. I will check the functionality and let you know how it is working. Thanks, Again Sir