Page 1 of 1

Need Help tuning MSSQL on seperate server from PHP code.

Posted: Tue Jan 24, 2006 3:52 pm
by waskelton4
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().
Box 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
Thanks for any help you can give

Will

Posted: Fri Jan 27, 2006 9:19 am
by waskelton4
anyone have any idea where I should start looking?