Ben C wrote:Hi
There are several different uptime estimates that we could make:
1) Uptime of the machine (based on whether we could ping it)
2) Uptime of the SQL instance (based on whether we could execute SQL)
3) Uptime of the SQL instance (based on whether the service was running)
However, the estimate would only be valid if SQL Monitor was running successfully over the same time period. If SQL Monitor or the machine running SQL Monitor failed then the value would be incorrect.
If that is OK, we could suggest some SQL to calculate one or more of these estimates. Which would be most useful?
Users browsing this forum: No registered users and 0 guests