Node.js mssql UPDATE Statements take > 1 minute to Execute
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