4 Replies Latest reply on May 8, 2012 8:21 AM by bsawaqed

    Monitor DB servers and know the primary\standby

    bsawaqed

           Hello

           i have a punch of database servers (Windows/Linux) and these nodes have been sorted as primary and standby

       

      for example

       

      i have :

       

      DB Instance NameVnameCurrent Active Node NameIP AddressCurrent Non-Active NodeIP 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

        • Re: Monitor DB servers and know the primary\standby
          Fodome

          Hello Bsawaqed,

           

          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.

           

          Thanks.

           

          Sincerely,

           

          Chris Foley | Support Representative

          SolarWinds | IT Management, Inspired By You

          Support:866.530.8040 || Fax:512.857.0125

            • Re: Monitor DB servers and know the primary\standby
              bsawaqed

              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

                • Re: Monitor DB servers and know the primary\standby
                  Fodome

                  Bsawaqed,

                   

                  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.

                  Chris Foley