August 10, 2011 at 2:21 am
Hi,
I want to measure database availability for a particular month say for July 2011. Any idea how to do that? Any tools to measure it? Database availability is one of our project KPI.
Any help will be appreciated.
Ryan
//All our dreams can come true, if we have the courage to pursue them//
August 10, 2011 at 3:56 am
For a database you could throw a simple query at it every 5-10 minutes and log "success" in a table.
If you want to do it at Server level, report back the time the SQL server last started to show the "uptime"
SELECT sqlserver_start_time
FROM sys.dm_os_sys_info;
August 10, 2011 at 5:24 am
There's nothing within SQL to do this as the dmvs get cleared on a restart. As suggested unless you buy a monitoring tool you can only record a database availability by running a query against it and storing the results.
It depends upon the granularity you require, every 5 to 10 mins would miss, say, a 3 minute outage. I monitor servers/databases using perfmon written to a database ( on another server ) this I can run at 5 sec granularity and simple queries can show when things happen, however which counter you might like to use to show availability is another matter. My apps/dbs are 7 x 24 and have a degree of activity monitoring from within the apps - this is also a good way to see if the database is available; lots of variations on what you might consider " available"
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply