elastic / elastic/integrations

Elastic-Agent: Microsoft SQL Server Integration - manage failover in a Microsoft SQL cluster

Open
#4,272 8 comments 0 reactions 0 assignees View on GitHub
Integration:microsoft_sqlserver Team:Service-Integrations
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.