Activity overview
Latest activity by kmonroe
Thanks for the Reply Chris. So SQL Monitor doesn't periodically recheck to see if the database is back online after being marked as offline?
I know that it repeatedly checks to see if the state changes from online to anything other than online. I've seen the database unavailable alert when performing a restore or if SQL monitor checks a SQL Server after a restart before all of the databases have gone through crash recovery.
Either way, that is good to know. I'll have to remember to recheck the instance in SQL Monitor the next time the instance is restarted.
Thanks again,
Kevin / comments
Thanks for the Reply Chris. So SQL Monitor doesn't periodically recheck to see if the database is back online after being marked as offline?
I know that it repeatedly checks to see if the state ch...
Database displayed as Offline
I have an instance that I'm monitoring that has 45 databases. Two of the databases are displaying "Offline" in SQL Monitor but in SQL Server they are online.
Any Ideas??
Kevin
Issue monitoring clustered SQL Server - WMI Cannot Connect
Can someone help me out with this. I'm trying to monitor a cluster. Everything connects just fine with the exception of the actual cluster itself. We receive the following error in the SQL Monit...
Chris - Thank you for the reply. I've used regular expression exclusions for other alert configurations. My issue is that the process that is displayed when the maintenance plan runs is "SQL Server Management Studio". If I excluded this process any long running query that a user runs from SSMS would be excluded.
I think I'm going to have to use Regular Expression to exclude the TSQL that the plan executes.
Any other ideas?
Regards!
Kevin / comments
Chris - Thank you for the reply. I've used regular expression exclusions for other alert configurations. My issue is that the process that is displayed when the maintenance plan runs is "SQL Serv...
Need help configuring Long Running Query alert...
Hey All...
I'm working through some alert configurations in SM and I have a SQL Server maintenance plan that is generating a lot of alerts for processor utilization, physical memory and long runnin...