December 28, 2011 at 4:27 am
One of the customers took a database offline in one of the sql server 2005 instances and wanted to findout if we get an alert or not through the monitoring tool which is capable of being configured for all the parameters which are available in perfmon.
Do we have a performance object which can tell us when the database goes offline?
December 28, 2011 at 6:48 am
itsamarnath (12/28/2011)
One of the customers took a database offline in one of the sql server 2005 instances and wanted to findout if we get an alert or not through the monitoring tool which is capable of being configured for all the parameters which are available in perfmon.Do we have a performance object which can tell us when the database goes offline?
Check status of the database on sysdatabases... details here: http://qa.sqlservercentral.com/Forums/Topic583990-146-1.aspx
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 28, 2011 at 7:00 am
One of the customers took a database offline in one of the sql server 2005 instances and wanted to findout if we get an alert
If the Database is already offline, it’s too late for setting up an alert. However it would be good to setup an alert on it in future alerts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply