|
Home > Archive > MS SQL Server > August 2005 > SQL & IIS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Mike Collins 2005-08-09, 11:23 am |
| We have a box that is hosting IIS and SQL Server. The box is very slow and we
are reviewing the indexes to see where we can get any speed. One question I'd
like to ask is Can anyone explain if it would be a significant gain, in
speed, to separate IIS and SQL Servers to separate servers?
| |
| David Browne 2005-08-09, 11:23 am |
|
"Mike Collins" < MikeCollins@discussi
ons.microsoft.com> wrote in message
news:8A6DE6D5-6073-4270-8A67- 46C487E03BA0@microso
ft.com...
> We have a box that is hosting IIS and SQL Server. The box is very slow and
> we
> are reviewing the indexes to see where we can get any speed. One question
> I'd
> like to ask is Can anyone explain if it would be a significant gain, in
> speed, to separate IIS and SQL Servers to separate servers?
IIS and SQL Server can contend for CPU and memory on the server, and
seperating them can give you a more scalable solution.
However, there's no guarantee that _your_ problem is related to resource
contention between SQL and IIS. Often, especially for small databases
dedicated to servicing a web site with a small number of concurrent users,
SQL and IIS cooperate very efficiently.
David
|
|
|
|
|