SQL Monitoring
Hi,
I am looking for a way to monitor several SQL servers including several SQL AAG clusters. I have SCOM available to me but haven’t found it very useful thus far. I want to monitor things like if the AAG failed over or what node is running as primary. I want to see if databases are healthy and synced up or if a node is not functioning like I would expect. I would also like to monitor disk space and CU level if I could. I wanted to see what other people are using that they like. I an envisioning a dashboard of sorts but I open. I also would prefer to find a free solution if I can or use what I have available. Thanks in advance!
Hi,I am looking for a way to monitor several SQL servers including several SQL AAG clusters. I have SCOM available to me but haven’t found it very useful thus far. I want to monitor things like if the AAG failed over or what node is running as primary. I want to see if databases are healthy and synced up or if a node is not functioning like I would expect. I would also like to monitor disk space and CU level if I could. I wanted to see what other people are using that they like. I an envisioning a dashboard of sorts but I open. I also would prefer to find a free solution if I can or use what I have available. Thanks in advance! Read More