- Need to check Node.js application is compatible with the SQL Server 2014 version.
- Need to manage connection pooling as par application usage ( min: specifies the minimum number of connections that the pool should always maintain) (max: This value should be determined by considering the capacity of your SQL Server and any limitations it may have.)
- Check After updating the statistics of the table because outdated statistics can also mislead the query optimizer (Command: UPDATE STATISTICS Table name;)
- during update query execution there are any other transaction blocks a table at that time it takes more time for execution
Support On Demand!
