Monitoring Cluster Shared Volumes in SAM

Question

HI

Has anyone come up with a good way of monitoring cluster shared volumes within SAM for SQL server clusters?

We are currently building a 10 node windows cluster for SQL always on consisting of one 4 node SQL cluster and three 2 node SQL clusters all using CSV.  We would like to monitor the free space on these CSVs and associate the appriopriate ones with each SQL server being monitored within Solarwinds SAM, Appinsight and DPA.

chad.every · Answer

What I've done in the past when I monitored a 2-node SQL failover cluster is this.

1. Create a Node in Orion using the cluster VIP. This is where I would monitor all of the shared resources (CPU, RAM, Disk and Application templates)

2. Create Nodes in Orion using each of the nodes in the cluster. I would monitor non-clustered resources, e.g. C: drive, non-clustered services, etc

In my scenario I ended up with 3 nodes: node1, node2, nodeVIP.

lindsey.serrano · Answer

Hi Mark,

Attached below are some articles that you might find helpful.

Monitor clusters with AppInsight for SQL - SolarWinds Worldwide, LLC. Help and Support

Monitor an active/passive SQL Server Cluster - SolarWinds Worldwide, LLC. Help and Support