Setup of iis and sql server on two machines

Hello

I have inherited an internet application which to me, seems rather bizarrely setup but I was wondering if anyone may be able to tell me if I'm just being paranoid

We have two servers, one IIS, one sql server installed on the two machines respectively and we are running asp pages with a few components. Here's the thing; the asp pages are held on the held on the same server as the server with sql server and are called across a mapped network drive from IIS

To me, this seems strange as IIS is going to have to request the page across a network drive and process it; within this making calls to the sql server (again passing information between the two

I guess what I'm asking is that I am trying to improve the performace of the site, is changing this to a more traditional (in my view) sql on one server and iis and it's asp pages on the other as part of my upgrades or will this not be causing any problems

I have had trouble finding any articles on this so any help would be appreciated

Many thanks

Steve King

Tom
Tue Apr 27 07:14:01 CDT 2004

"steve king" <steveking@movietrak.com> wrote in message
news:8A4FCA62-E47B-449A-9D1C-F9CBD6BBB097@microsoft.com...
> Hello,
>
> I have inherited an internet application which to me, seems rather
bizarrely setup but I was wondering if anyone may be able to tell me if I'm
just being paranoid.
>
> We have two servers, one IIS, one sql server installed on the two machines
respectively and we are running asp pages with a few components. Here's the
thing; the asp pages are held on the held on the same server as the server
with sql server and are called across a mapped network drive from IIS.
>
> To me, this seems strange as IIS is going to have to request the page
across a network drive and process it; within this making calls to the sql
server (again passing information between the two)
>
> I guess what I'm asking is that I am trying to improve the performace of
the site, is changing this to a more traditional (in my view) sql on one
server and iis and it's asp pages on the other as part of my upgrades or
will this not be causing any problems?
>
> I have had trouble finding any articles on this so any help would be
appreciated.

Generally speaking, you want to have your ASP code local to the IIS server
and not on a shared network path. I would want to change it too ...

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

steveking
Tue Apr 27 07:46:04 CDT 2004

Thanks for your help Tom.
Steve