I have 2 nodes active/active with 3 virtual instances.
2 instances on node 1 and 3d instance on node 2.
Sometimes they automatically change from node 1 to node 2.
Is there any way that I get some notification regarding the instance that have changed from one node to another?
I found following may be probable solution:
EXEC master..xp_cmdshell 'cluster resource "SQL Server (Instance Name)"'
Result: Instance Name, Node Name
Put results into table..........Again run the command.....compare.......too much stuff.....
If someone knows the easy path to this.......
How could I get the information that has been changed?
Your help would be really great!
View Complete Post