Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brkonthru
Starting Member
31 Posts |
 Posted - 2001-05-13 : 21:31:05
|
| Hi,I used to run my web and db (sql 7) on the same server, but now since my website has been getting more hits and signs of maxed out capacity were showing i thought i needed to change the configuration.I bought another server (w2k AS) and decided to move the webserver to the new machine and keep the sql server on the current machine (nt 4 sp6a)I was always told that ther performance of websites accessing a seperate backend sql server would increase as oppose to having the webserver and db on the same machine since the sql server will have more room on the machine (cpu+memory) to do its job.This has not been the case with me, im testing now my website's speed on the new machine and its quite slow retrieving information from the sql server, they are both on the same network and on the same hub. Here is the connection string that I use:"Provider=sqloledb;server=IPADDRESS;database=;uid=id;pwd=pwd;"Does anyone know why this would be happening or any typs on how to make the connection between the webserver and the sql server faster?thank you,Edited by - brkonthru on 05/13/2001 21:36:35 |
|
|
|
|
|
web server accessing sql server