templar1980

Just what I needed. Thanks!!!

Found what I needed in this post: http://thwack.solarwinds.com/ideas/2669

Great idea I'm looking for just this feature.

I've been using the feature for a little while now. This is what it looks like in SSMS its very useful and hands the power back to the DBA from the cluster administrator :-). I would like to monitor this effectively using solarwinds if possible.

Hi alterego that is exactly what I'm doing. It's a two node cluster with aprox 10 instances 5 active on each node. I monitor each via its own VIP but will not gather stats if there is more than a single instance monitored by appinsight.

Sorry this took me a while to back to you. I tried your advice and it worked for a while so I've been doing some troubleshooting and here is what I found: we have have an active/active sql failover cluster with multiple instances.. * Add the VIP on the first instance to Insight for sql. * allow the initial poll to…

Hi Alterego thanks for your help so far, I've have tried the sugestion to add the VIP to appinsight and but unfortunatly I keep getting: I've monitored the SQL instance and I can see the solarwinds account connect and start to run a number of processes but it seems to give up after a little while (we have 60+ databases…

Thankyou I will give that a try tomorrow.

I'm using appinsight with SAM 6 which works great for intances that are not clustered.

Thanks for this. I'm not looking for AppInsight to run the checks but just report on the last time it was ran. I will give the SQL User Experience Monitor a try. Thanks

Thanks I'll open a ticket today