tracker issue : CF-4205369

select a category, or use search below
(searches all categories and all time range)

Slow database performance - Windows 2012 vs Windows 2016/2019 - ColdFusion 2018

| View in Tracker

Status/Resolution/Reason: Open//

Reporter/Name(from Bugbase): Michael T. / ()

Created: 10/04/2019

Components: Database

Versions: 2018

Failure Type: Performance Issue

Found In Build/Fixed In Build: ColdFusion 2018 Update 3-5 /

Priority/Frequency: Normal / Some users will encounter

Locale/System: English / Win All

Vote Count: 0

We are having an issue when executing either queries or stored procedures with CF2018 running on Windows 2016/2019. The same code running on Windows 2012 runs fine, however when executed on Windows 2016/2019 the execution times are 5-10x (at least) as long. The database server is MS SQL Server 2012. 

Enabling logging on the datasource indicates the slowdown occurs at PreparedStatement[n].execute() . On Windows 2012 it takes 15ms vs 265ms on Windows 2016/2019. We have tested this using CF2018 update 3-5 and recevied the same results, looping the same query up to 200 times. 

Could this possibly be related to nvarchar?  See attached screenshot. I am sure the query could be optimized but we can not determine a valid reason of the slow performance due to the Window OS.