Need Help tuning MSSQL on seperate server from PHP code.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
waskelton4
Forum Contributor
Posts: 132
Joined: Mon Sep 09, 2002 6:42 pm

Need Help tuning MSSQL on seperate server from PHP code.

Post 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
waskelton4
Forum Contributor
Posts: 132
Joined: Mon Sep 09, 2002 6:42 pm

Post by waskelton4 »

anyone have any idea where I should start looking?
Post Reply