We have a SQL Server Cluster in use.
Node 10.0.0.4 and node 10.0.0.5, the virtual IP of the cluster is 10.0.0.1.
In OPManager we managed to create a business view to group the nodes to form the cluster dependencies (SQL Server, ...)
One of our application is updating a log file every 30sec. This log file is created always on the active node (10.0.0.1, d:\log\log.txt). To monitor, if the application is still alive AND working, we want to create a File Monitor that checks the file age and creates an alert, if older than 5 minutes..
We fail to create the File Monitor on the cluster (10.0.0.1) - the file cannot be found. It is working, if we choose the active node of the cluster (10.0.0.4) - the file can be found and we get the details.
But when the cluster does a node switch, the monitor will fail, because the file will be updated on the 10.0.0.5.
The SQL Server monitoring is capable of moving with the active node, how can this be done with a File Monitor?
Anybody a idea, how a file monitoring can be done on a cluster?
Thanks and best regards,
Martin