Red Gate forums :: View topic - request for uptime or availability report
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

request for uptime or availability report

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
hbuckner



Joined: 16 Jun 2006
Posts: 61

PostPosted: Tue Nov 23, 2010 11:28 pm    Post subject: request for uptime or availability report Reply with quote

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
Back to top
View user's profile Send private message
Ben C



Joined: 13 Jul 2009
Posts: 15
Location: Red Gate Software

PostPosted: Tue Nov 30, 2010 3:18 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
hbuckner



Joined: 16 Jun 2006
Posts: 61

PostPosted: Tue Nov 30, 2010 3:52 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Ben C



Joined: 13 Jul 2009
Posts: 15
Location: Red Gate Software

PostPosted: Tue Nov 30, 2010 5:13 pm    Post subject: Reply with quote

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

Thanks
Ben
Back to top
View user's profile Send private message
hbuckner



Joined: 16 Jun 2006
Posts: 61

PostPosted: Tue Nov 30, 2010 5:47 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Torrico



Joined: 09 Jun 2012
Posts: 1

PostPosted: Sat Jun 09, 2012 7:55 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group