Supported Configuration?

SQL Server performance monitoring and alerting

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

Supported Configuration?

Postby gsinclair » Wed Aug 15, 2012 8:36 pm

I'm testing this setup to deal with one of our more secure servers, and I think I'm running into this problem.

Consider this 2 node cluster:
Cluster IP - xxx.xxx.xxx.1 (cls1)
SQL Virtual IP - xxx.xxx.xxx.2 (cls1sql1)
Node1 - xxx.xxx.xxx.3 (cls1node1)
Node2 - xxx.xxx.xxx.4 (cls1node2)

Now if the firewall rules say that only cls1sql1 has 1433 open, does that mean that even though SQL Monitor figures out that cls1 is the name of the server, will it also know to use cls1sql1 to connect to the sql instance?
gsinclair
 
Posts: 1
Joined: Wed Aug 15, 2012 8:24 pm

Postby chriskelly » Fri Aug 24, 2012 3:50 pm

When an entity, like a cluster, is added to be monitored SQL Monitor will look for certain details to decide whether the entity is a host machine, part of a cluster, a sql server instance etc. Where it detects that it is a cluster, it will then add the nodes and the hosted SQL Server instances. So in your above scenario, I would expect SQL Monitor to detect the correct way to monitor the sql instance.

If you test the connection and find that it is having problems, please get in touch with the support team, either by phone or by emailing support@red-gate.com.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests