i have a punch of database servers (Windows/Linux) and these nodes have been sorted as primary and standby
i have :
|DB Instance Name||Vname||Current Active Node Name||IP Address||Current Non-Active Node||IP Address|
how i can implement this on solarwinds so i can monitor and creat a map regardinng.
please advise if there is a way to implement this
How are you able to monitor this visually? Is it via a web page, a database query, the VM Ware interface?
If you can offer more information as to where the information is coming from, I can perhaps provide a solution or an idea.
Let me know.
Chris Foley | Support Representative
SolarWinds | IT Management, Inspired By You
Support:866.530.8040 || Fax:512.857.0125
actually, my DB info as before, i need to monitor this, for example US country i have TNS-ping file has all the DB instances ,,, theses DB instances are taking data from Virtual name DB in my company records, ping this vname db leads to primary/standby node(database). i need to monitor this vname and when failover happened from SW i need to confirm that this the failove DB ,
if i was on standby server as vname then i failover the primary db will appear as the active node .
in map contain this data on SW i can see for example the 2 db nodes and the active with light indicates that.
that's my request, please help/advise
TNS-Ping? That sounds like Oracle. Are you able to see the status for each database via an SQL query? If so, you could use the ADO Query Monitor to query the status of each database. The only concern is what to use as a threshold? If value of Row x is equal to 'Primary', pass. If otherwise fail? This would result in Monitors for databases that are not the primary to constantly fail until their status changes.
The other option, which would pass Information Notifications instead of Failure Notifications would be to use a File Watching Monitor, an Event Log Monitor or an SNMP Trap Monitor. This is assuming your database servers can submit database status changes via an SNMP Trap, a text file or an Event Log.
Hope this helps.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.