Databases saying offline in Windows 2008 cluster

SQL Server performance monitoring and alerting

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

Databases saying offline in Windows 2008 cluster

Postby Kwisatz78 » Fri Nov 16, 2012 2:34 pm

Hi

We recently purchased SQLMonitor however I am getting some strange behaviour.

We are using Windows 2008 SP2 Ent and I was getting thousands of what is described in the below link.

http://www.red-gate.com/MessageBoard/vi ... hp?p=57304

I then performed the fix which surpressed the alerts, however SQLMonitor is saying all my databases are now offline, when they are not.

Can anyone help?

Thanks
Kwisatz78
 
Posts: 7
Joined: Mon Oct 18, 2010 4:29 pm

Postby RajK » Mon Nov 19, 2012 7:43 am

Your question has been passed to Product Support and has raised a support call. Please send your logs to support@red-gate.com with the following in the subject line:

F0066891 - (Forum) Databases saying offline in Windows 2008 cluster

When SQL Monitor indicates 'Offline', it often means that SQL Monitor has lost contact with the host machine and/or sql server instance.

Please check that you have entered the machine name and password correctly. Then refer to the 'Show Log' page and check that all the connections are working. If you encounter any difficulty then please send me screenshots of the 'Show Log' page and the SQL Monitor log files, which are detailed in this document:

http://www.red-gate.com/supportcenter/C ... %20Monitor

Also let me know if restarting the base monitor helps fix the connection issue?

Thanks for your patience and feedback in this matter.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am

Postby Kwisatz78 » Mon Nov 19, 2012 2:32 pm

Have sent logs as requested
Kwisatz78
 
Posts: 7
Joined: Mon Oct 18, 2010 4:29 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron