We are moving to a new ERP system next year based upon a SQL database. Max
100 users, generally between 50-60 users. I've tried to find out what the
recommendations are for running SQL on a different server to the actual ERP
system, but there don't seem to be any. Would anybody have any comments /
thoughts / recommendations?
Ideally, SQL Server should be on its own server for resource
utilization....memory, CPU and disk subsystem should not have multiple
applications fighting for them....

Signature
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
> We are moving to a new ERP system next year based upon a SQL database. Max
> 100 users, generally between 50-60 users. I've tried to find out what the
> recommendations are for running SQL on a different server to the actual
> ERP
> system, but there don't seem to be any. Would anybody have any comments /
> thoughts / recommendations?
TonyS - 29 Jul 2005 16:49 GMT
Appreciate the comments - it confirmed what I thought
Regards
Tony
> Ideally, SQL Server should be on its own server for resource
> utilization....memory, CPU and disk subsystem should not have multiple
[quoted text clipped - 6 lines]
> > system, but there don't seem to be any. Would anybody have any comments /
> > thoughts / recommendations?