Logstash jdbc plugin with MSSQL

Elastic Stack Logstash
8

It looks like TOP and ORDER BY are not being applied in the expected order. Perhaps try something like

SELECT TOP(100) * FROM 
   (SELECT * FROM DBTABLE with(nolock) where LogDate > :sql_last_value ORDER BY LogDate ASC)

Not sure if you need as someAlias or not, I don't really speak SQL.

Or else use the paging that the input supports as Murat suggested.