• 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!