Need Help tuning MSSQL on seperate server from PHP code.
Posted: Tue Jan 24, 2006 3:52 pm
Howdy Group,
Hope that subject made sense.
I have a web application that pulls data from two different sql servers. One MySQL and one MSSQL, both are seperate from the webserver. Since I've setup the applicatoin I have had very few speed issues with the mysql server. I can't say the same thing about the MSSQL server though. The other thing is that my test webserver is on the same server that runs the MSSQL database. I have no speed issues with the test data or system. Only with the production.
Is there anything I can do to speed up the connections between the production webserver and the mssql db server?
All Three servers are running Windows 2003, the mssql php libraries are identical on the test and production webservers based on phpinfo().
Will
Hope that subject made sense.
I have a web application that pulls data from two different sql servers. One MySQL and one MSSQL, both are seperate from the webserver. Since I've setup the applicatoin I have had very few speed issues with the mysql server. I can't say the same thing about the MSSQL server though. The other thing is that my test webserver is on the same server that runs the MSSQL database. I have no speed issues with the test data or system. Only with the production.
Is there anything I can do to speed up the connections between the production webserver and the mssql db server?
All Three servers are running Windows 2003, the mssql php libraries are identical on the test and production webservers based on phpinfo().
Thanks for any help you can giveBox 1 (Production Web Server)
IIS6, PHP 4.3.7
Box 2 (MSSQL Server, TestWebserver)
MSSQL 2000, IIS6, PHP 4.4.1,
Box 3
MySQL Server: MySQL 4.1.10a
Box1 <-> Box3 = fast
Box2 <-> Box2 = fast
Box1 <-> Box2 = slow
Will