Query for SQL uptime?
I'd like to create an uptimeavailability report.
What I'd like is similar to what the front end captures i.e.
How long has SQL Monitor been able to connect to the instance?
I know I can capture how long the server or instance has been up however, ideally I'd like to know how long it's been accessible over the network.
Does anyone have some sample t-sql I can use to pull this information out of SQL Monitor db?