I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk stack.
What is the best and performant way to send these kind of logs to a log collector?
I searched for a native way for logstash, filebeat, winbeat, nxlog, ... to send the logs to these kind of log collectors, But I can't find a reliable native way.
I know Extended Events is a right tool for gathering logs. I want to know how can I send these logs to a data collector.
Is there a raw log file from extended events? Or is there any way to send logs automatically through the network with some kind of standard protocol like syslog(rsyslog) in Linux? Or any other standard way?