Sqlserver database overwhelmed by logstash jdbc input

I am trying to get data from a MSSQL database using logstash jdbc-input. The database seems overwhelmed by the requests made by logstash, creates a lot of fake_worktable, and access to the database for other users are slow as soon as logstash script is started.
Is there a way to prevent this?

What use can have jdbc_fetch_size in this context?

Thanks in advance for your feedback

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.