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?