connecting server to another server hosting MS SQL slow problem
i have 2 server over at SM and TP ( one each ) , the one in SM is hosting a MS SQL , whereas the one in TP is hosting the script
originally i run my script on the same box with the MS SQL , but due to expansion plan i decided to have a dedicated MS SQL box and then the script running on another server.
i run a ping test between the 2 server and the average is less than <1ms
the problem is , originally the script running on the same MS SQL box execute a script at a total loading time of 2.XXX secs , but when i use the TP box and run the same script to run the same process , it took 22.XXXX sec , both the script connects to the same DB and does the same thing , but why so much of the time loading difference ????
can someone please advise how i can solve this issue to make sure that TP scripts run faster than the original script running on same box as MS SQL ???
my MS SQL box is only a P4 2.8 with 1gig ram running on normal 7200 RPM hdd , whereas my TP box is dual xeon 2.8 with 2 gig ram and running on SCSI HDD.
thank you for yoru kind advice
regards
