How know if Azure SQL Server rebooted?

Setting up a Azure Sql Database server guarantees HA (99.9 SLA in that region only). If the server reboots, the HA "twin" will take over for it. How can I check if such a reboot has actually happened given I don't have any direct access to the Azure SQL server?

TIA,

edm2

August 24th, 2015 3:01pm

SELECT DATEADD(ms, AVG(-wait_time_ms), GETDATE()) AS approximate_restart_date FROM sys.dm_os_wait_stats w WHERE wait_type IN ('DIRTY_PAGE_POLL','HADR_FILESTREAM_IOMGR_IOCOMPLETION','LAZYWRITER_SLEEP','LOGMGR_QUEUE','REQUEST_FOR_DEADLOCK_SEARCH','XE_DISPATCHER_WAIT','XE_TIMER_EVENT')

Free Windows Admin Tool Kit Click here and download it now
August 24th, 2015 11:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics