elastic / elastic/integrations
Elastic-Agent: Microsoft SQL Server Integration - manage failover in a Microsoft SQL cluster
- Dominant language
- Handlebars
- Stars
- 333
- Forks
- 647
- Avg merge
- 2d 18h
- Merged PRs (30d)
- 182
Description
**Currently**
A named instance can be running on a machine and the 'Microsoft SQL Server' integration connecting to localhost: instance port, or the machine ip: instance port. (We are not talking here about the instance vip:instance port)
**Issue**
If the sql instance goes down, because it was moved to the other machine of the sql cluster, then the integration, actually elastic-agent, will fire a lot of errors (and possibly stops collecting logs ...). As it is not an error actually, this failover should be detected and message turned into WARNING or INFO level , not ERROR and message fired a few times. (this does not prevent the integration from trying to reconnect regularly to the instance until it comes back to the machine)
Thanks
Contributor guide
Assessment
This issue has not been assessed yet.