CF 9 Enterprise -> SQL Server 2008 SLOW

Report · May 05, 2010

Hello all-

We've been running CF8 standard on a 32 bit Windows Server 2003 box. Everything is fine and dandy.

We are upgrading to CF9 Enterprise on a 64 bit Windows Server 2008 r2 box, but things are not going well.

Both of these servers are connecting to the same database, on the same SQL Server 2008 instance.

I am having some fairly serious slowdowns in our SQL queries on our new CF9 box. Queries that are taking 30 milliseconds on the old server, are taking 250+ milliseconds on the new server. This is happening between different databases, different queries, etc. This new server is just a whole lot slower when connecting to the exact same SQL Server.

I've pinged our database server from both CF servers- no difference. (Both are 0 ms)

The old server is running version 2000.86.3959 of the SQL Server driver (2/17/2007).

The new server is running version 6.01.7600.16385 (7/13/2009)

Any ideas as to what could be causing the slowdown?

Thanks,

Karl

Message was edited by: karlkrist to add sql server driver versions

Report · May 06, 2010

I've never encountered this problem, I'm not using CF9 or SQL 20008; but here are some things to investigate.

1. Are there any differences in the way your datasources are configured in CF between the two servers. For example, do you have the "Maintain Connections" option enabled on one server's datasource, but not the other?

2. You might try using an alternate JDBC driver to see if this issue is caused by the drivers. Microsoft produces as JDBC driver for SQL server and I think there may be open source options.

Microsoft's JDDB driver:
http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en