Hello ,
I would need your advice on which parameter is least impacted in terms of Data Loss if we wanted to set .
One of our Database is waiting on I/O when there is a batch operation that runs to Insert/Delete table data is impacting the small updates that runs on a continuous basis where it shows that wait is on walwritelock.
commit_delay
synchronous_commit
Thanks,
Naveen.
