I'm using a 30 demo of ManageEngines OpManager to monitor our network and applications. As soon as it found the SQL Service it triggered some alerts because our server values exceeded its thresholds. I know I need to adjust these thresholds but I'm not sure what values they should be for our environment. So I came here to ask a couple of questions.
Are these the metrics I need to be concerned about or should I just remove them and use different ones? If there are some I should monitor what would be the best way to determine what is normal for our server?
Active Connection
SQL Compilations per second
SQL Cache Memory
Lazy Writes
Data/Log files Sizes
Granted WorkSpace Memory
Logins per secound