0 Replies Latest reply on Nov 29, 2019 10:24 AM by Farhood Nishat

    Solarwinds Database Monitoring

    Farhood Nishat

      I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are

      1- CPU Wise Most Expensive Queries

      2- Queries Having Most Physical Reads

      3- Long Running Stored Procedures and Scripts

      4- Dead Locked and Dead Locking Queries/Scripts/Procedures (Real Time and Within Specified Time Range)

      5- Head Blocking Queries In Specified Time Range

      6- Active Database Connections and History In Defined Range

      7- Open Transactions on Production Databases

       

      I have a demo scheduled with SentryOne team and after that I'll do for the Solarwinds demo. What you guys prefer how should I go along with this task?