Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mauricio Moreno
Starting Member
18 Posts |
 Posted - 2007-04-11 : 20:51:54
|
| Hello,I am upgrading my site from a VPS with a shared SQL server to a dedicated server and my own sql server 2003 standard. My site is an ecommerce site with about 10,000 users a month with between 10-20 people on the site at one time.It is better to host both my site and the SQL server on the same system or is it better to have them on separate systems? if they are on the same system is 1 gig of ram enough? is will there really be much better performance with 2 gigs?Any information on the best way to do this would be greatly appreciated!!!Best regards,~ Moe |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-11 : 21:03:47
|
| It is much better to have dedicated server for MSSQL another dedicated server for web server.May run into serious memory (and CPU) contention issues if same server. Also likely to see I/O issues. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-04-12 : 01:30:30
|
| Separate servers for SQL and IIS.Kristen |
|
|
|
|
|
|
Should my site and sql be on the same server