how to load 500K messages from Kafka to SQL server?
Dears
i need yo make a job that read kafka messages and load them to SQL server, the issue here is that i am getting around 500k message per second from kafka, i created an in memory table in MSSQL 2019 yet i am not able to upload even 50% of the traffic
can you please help, in modifying the job to be able to read the messages and load them in SQL here is the job