Solved: Slow Performance of Inserts into Microsoft SQL Server

Some customers are reporting bad performance on running INSERTs, SELECT INTOs, replications into MS SQL server while using Microsoft JDBC Driver to connect (rather than the alternative jTDS driver). 

We have identified that the root cause for the issue is an open (as of time of writing this article) bug in the Microsoft JDBC Driver. The bug is described here

https://github.com/microsoft/mssql-jdbc/issues/1196

A workaround to this problem exists: if you experience this problem, please add the following parameters to the JDBC properties of the MS SQL data source:

statementPoolingCacheSize=10;disableStatementPooling=false;enablePrepareOnFirstPreparedStatementCall=true;

We will monitor the situation on the Microsoft side and update the driver in Data Virtuality release when the bug gets fixed. 

Please note that also Azure SQL Database is affected by this. For Azure Synapse we strongly recommend configuring bulk inserts over Azure Blob Storage for best performance, in this case the aforementioned issue is not relevant.