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?
SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website, you consent to our use of cookies. For more information on cookies, see our cookie policy.