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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-16 : 08:09:25
|
| Dragan Hanc writes "What problems will I encounter if i run SQL and IIS on the same box? Potentially even Rightfax?Thank you" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-16 : 08:14:15
|
| Memory contention, CPU contention, maybe disk contention if you store your database and web files on the same drive.SQL Server is going to try to bully them all over RAM, and will win too. The only way to stop it is to set an upper limit on the RAM SQL Server can use:EXEC sp_configure 'max server memory', '1024' -- this will limit SQL Server to 1 GB (1024 MB) of RAM, for exampleNaturally, if performance is a concern then you should not house these services on the same machine. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2005-02-16 : 12:53:14
|
| Actually I have also thought a little bit about this. Right now our production environment consits of 1 dedicated db-server (Win2kSP3 P4 2.4Ghz 1GB RAM RAID 1) and 2 dedicated webservers (Win2kSP3 P4 2.4Ghz 512MB RAM Single SCSI) but we have way to much capacity so I'm considering a downgrade. How would something like this compare to one single box with DUAL P4, 2 x RAID 1 and 2GB RAM where I set sql-server to use one processor and Win2k to use the other and specify the RAM for sql-server?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
SQL/IIS on the same box