4 Replies Latest reply on Aug 1, 2017 2:40 PM by skenow

    DPA report to show reads on secondary servers in a cluster

    skenow

      hi,

       

      in DPA or Solarwinds, is there any report or a way to show if any secondary servers in an AG Cluster are being used by the users for data reads?  (vs using the primary server?)

       

      thanks in advance! Susie

        • Re: DPA report to show reads on secondary servers in a cluster
          mandevil

          If you are using DPA to monitor both instances (the one hosting the primary replica and the one hosting the secondary replica), yes.

          You can do a report on the read-only instance just on the program in question or databases. Better yet though, you can go into trends for the secondary and drill in through the programs dimension to see all activity. This will show you who, what, where, when is being sent to the secondary read-only replica to be serviced.

          Let me know if you need more detail on how to do this, but you should have the ability to definitely show/see secondary usage.