request for uptime or availability report

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

request for uptime or availability report

Postby hbuckner » Tue Nov 23, 2010 11:28 pm

Is there any way to get a uptime or availability report out of the system with the data we are collecting. I need a % uptime over a span of time.

example: server was up 99.8%. I know there are a lot of factors if something is available but more interested if the SQL service is down ( long the alert was active) would subtract from the uptime.

Any idea how to go about this?

Thanks
hbuckner
 
Posts: 60
Joined: Fri Jun 16, 2006 6:37 pm

Postby Ben C » Tue Nov 30, 2010 3:18 pm

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?

Thanks
Ben
Ben C
 
Posts: 15
Joined: Mon Jul 13, 2009 12:56 pm
Location: Red Gate Software

Re:

Postby hbuckner » Tue Nov 30, 2010 3:52 pm

This is wonderful!

As a database administrator I would rather see Uptime based on the SQL instance. As far as either the (based on whether the service was running) or the (based on whether we could execute SQL), I quess either would be fine and which ever is easiest.

I nderstand about your statement: " If SQL Monitor or the machine running SQL Monitor failed then the value would be incorrect."

Thanks again.

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?

Thanks
Ben
hbuckner
 
Posts: 60
Joined: Fri Jun 16, 2006 6:37 pm

Postby Ben C » Tue Nov 30, 2010 5:13 pm

The script turned out to be quite long. Please email me at ben.challenor@red-gate.com to get it.

Thanks
Ben
Ben C
 
Posts: 15
Joined: Mon Jul 13, 2009 12:56 pm
Location: Red Gate Software

Re:

Postby hbuckner » Tue Nov 30, 2010 5:47 pm

Email on the way.

Ben C wrote:The script turned out to be quite long. Please email me at ben.challenor@red-gate.com to get it.

Thanks
Ben
hbuckner
 
Posts: 60
Joined: Fri Jun 16, 2006 6:37 pm

Postby Torrico » Sat Jun 09, 2012 7:55 am

Hi Ben,

Is there any chance the availability report is available in sql monitor 3.1?

I am in the process of looking for a monitoring tool that supports SLA reporting.

Thanks, Ron
Torrico
 
Posts: 1
Joined: Sat Jun 09, 2012 7:49 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests