I am using Sql Server Express, I have an instance installed in two virtual machines on the server, one of the installed instances is Sql Server 2008 , and the other is the Sql Server 2014
When executing the same query in both instances I have different response times, the 2008 version returns me the data without problems and quickly already the version 2014 delay too much to return the search result. Both instances have the same permissions on the server.
I would like to know if anyone can help me make the 2014 version can have the same performance as the 2008 version. I am using php with sql server .
In addition I noticed that in 2014 version the installed instance is consuming a lot of memory about 85% ram even after the query ends it continues to consume the same value.