Melanie:
[color=blue][color=green]
>>From everything I have read the best way to optimize your site is to[/color][/color]
use 2 separate servers one for iis/asp and one for sql server.
Adding a new layer to an environment will rarely gain you performance.
There is an extra network hop that the server has to make to retrieve
the data.
Having said that, you will most likely gain scalability which is
different from performance.
You might want to have some form of high speed or dedicated network
connection in between your web server and sql server. Although you
should first try to determine if the connection in between the servers
is really the problem here.
FYI, your server configuration is widely used. Unless you are
retrieving a very large amount of data, you shouldn't be able to tell
that BIG of a difference.
Hope that helps.
BZ
mblack@deltad.com (Melanie Black) wrote in message news:<3efc718d.0310291500.661bbaba@posting.google. com>...[color=blue]
> I am currently running a windows 2000 machine with asp, sql server,
> mail server, ftp server etc all on the same box.
>
> The site runs several hundred ecommerce stores. Recently the
> processor utilization has been spiking and I have decided to get
> another server and use sql server on one and asp on the other.
>
> So now I have a new windows 2003 server that I have setup all of the
> asp code on. Problem is that when I run the asp code from the new
> windows 2003 server it is extremely slow compared to the code running
> on the old windows 2000 server which is where the sql server database
> is also located.
>
> From everything I have read the best way to optimize your site is to
> use 2 separate servers one for iis/asp and one for sql server.
>
> Am I doing something wrong here or is this normal??
>
> Could this possibly be just because the old server is still serving
> many requests and is pushing the requests from the new server to the
> back of the line?
>
> Does anyone have any ideas?
>
> The syntax I am using to open the connection string is:
>
> db_ConnectionString = "Driver=" & db_Driver & ";Server=" & db_Server &
> ";UID=" & db_UIN & ";PWD=" & db_pwd & ";Database=" & db_Database & ";"
>
> conn_store.Open db_ConnectionString
> where db_server is the ip address of the windows 2000 server
>
> Is there a better way to do it across a network??
>
> Any help or ideas would be much appreciated.[/color]
