Hi,

our php based site went really slow after moving from sql server 2005 to sql server 2012. Only changes made to site are mapping to new sql server in define file.

Any ideas what coould cause this? Or how to fix this issue?

Thanks.

http://thomaslarock.com/2011/12/7-mistakes-you-cant-afford-to-make-when-upgrading-to-sql-2012/

Might help you, generally I think it's a bit slower.

Have done these steps but no luck.

Same page load took less than 1 second on sql server 2005, in sql server 2012 same load takes around 10 seconds. There must be something else than just slowiness of sql server 2012. :l

have you verified the sql is taking that long and not something else? i assume all your indexes/partitions/etc are there?

If I run the same queries directly in the database they are done in 0.05 second or less.

Have you tried memcached yet?

MSSQL isn't the best choice for a backend. Both costly to maintain and license.

there is software you can use that will tell you the params for every sp, every sql statement, execution times for each of them, graphs, etc. are you doing anything like that? or just assuming it's the database?

Havent tried this yet, have to take a look at it when I have time again. We have all the licenses already as its our companys production database.



No I havent used a software like that. Do you have any good software in mind?

What I did was trying the same query directly in database that runs in site. Also checked that ping is the same between servers.

This post was edited by vittujenkevat on Jun 5 2013 10:47am

Found the problem now. It was not the sql server itself causing the problem, it was network settings of server running the sql server 2012. After disabling Large Send Offload Version 2 and TCP Checksum Offload settings queries are fast like it was with the sql server 2005.