3
I am using Sql Server Express, I have an instance installed individually on two virtual machines on the server, one of the instances installed is the Sql Server 2008, and the other is Sql Server 2014
When executing the same query in both instances I have different response time, the 2008 version me returns the data without problems and quickly already to 2014 version it takes too long to return the search result. Both instances have the same permissions on the server.
I wonder if anyone can help me get 2014 version can perform the same 2008 version. I’m using php with sql server.
Also I noticed that in the 2014 version the installed instance is consuming a lot of memory approximately 85% of ram even after the end of the query it continues to consume the same value.
Ever tried to increase CE in Sqlserver 2014 to 120 or less ? Take the test
ALTER DATABASE seuBanco SET COMPATIBILITY_LEVEL=110;
GOforehead 100, 110 or 120.– Robss70
Try to update the version of the Driver you are using with PHP and also the version installed on the machine. Both versions are express?
– gmsantos
I was told that the 2008 version is paid and the 2014 is express. I tested the same program in sql server 2014 express on my machine and the performance was good.
– Airon
First make sure which side is the problem. Run a test by running the direct query in Management Studio, if the answer is quick, then you already rule out problems in sql server 2014, if it is still slow, you already rule out problems related to php
– Ed Cesar
Continuing... It can be many things, I suggest first to go decreasing the causes, the fewer things you have to analyze, the faster and easier it will be to find the problem
– Ed Cesar