We are trying to get a new Web Server up and running but are getting horrible performance when attempting to query our SQL server.
New Web Server is a HyperV virtual machine running Server 2008 R2 64 bit, IIS 7.5 with 3GB memory.
Our SQL Server is dedicated Server 2003 64 bit machine with 4 physical processors and 16GB RAM running SQL 2005.
Both the new web server and the existing production web server are in their own separate DMZs
Our existing production web server and all development clients can access the SQL server without any problems, but a query that runs in under a second on those machines takes 5 minutes to run on the new test server.
We've verified that it has the correct SQL client protocols and opened up the Firewall between the web server and the SQL server, but queries still take forever. Not sure what to even look for next. Figure if it was a firewall problem, that queries wouldn't run at all.
Any suggestions on what to look for next?