Running the related program on the save server as the database

Hello Community
I have a question relating to the recommended setup of the sql server. We
use sage with sql backend, both running on the same server. we are
experiencing major performance degradation over the WAN but not on the LAN,
the sage support are blaming the network, i am blaming the server, as when we
reboot the server the performance picks up again over a period of 10 days the
performance dies.
I am asking of there are known issues running the program on the same server
as the database.
Regards
AndyAndy
In general it is recomended to have a server dedicated to SQL Server only.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy|||If you are seeing poor performance over the WAN at the same time the LAN is
performing adequately then Sage is probably correct that you have a network
issue.
As far as running SQL and the application on the same server... I know the
*recommended* practice is to dedicate a server to SQL, but realistically
that costs $$$. As long as the two applications are not bumping into each
other and causing memory, disk, or processor contention then they should be
ok on the same server. The only way to tell is to fire up perfmon and let
it run for a while and see if your server is running short on anything.
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:71F12DDD-D3D4-4274-AAFB-0AC850B4CC24@.microsoft.com...
> Hello Community
> I have a question relating to the recommended setup of the sql server. We
> use sage with sql backend, both running on the same server. we are
> experiencing major performance degradation over the WAN but not on the
> LAN,
> the sage support are blaming the network, i am blaming the server, as when
> we
> reboot the server the performance picks up again over a period of 10 days
> the
> performance dies.
> I am asking of there are known issues running the program on the same
> server
> as the database.
> Regards
> Andy