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-09-26 : 12:51:05
|
Hello,I have a dedicated IIS machine for my ecommerce site with 2gigs of ram. I host my website and SQL Express for the site on the server, and nothing else really. Now lets say on Monday the server is using 489MBs of 2 Gigs, by Wednesday the ram will be at 1.2 gigs of 2 gigs. Ill reboot the machine and its back at 489mb but by friday its at 1.2 gigs again. and i have to repeat this process every few days.Now im guessing this is not normal, does anyone have any ideas why this might be happening and if its related to SQL.Thank you,~ Mauricio Moreno |
|
X002548
Not Just a Number
15586 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2007-09-26 : 15:01:02
|
Doesn't wound like you have "a dedicated IIS machine for my ecommerce site" but rather a single machine running both IIS and SQL Server.If so that will work OK, but its nothing like as good as a sever dedicated to each of those two tasks (well, assuming a reasonable amount of "ecommerce").We have a shared IIS server and a shared SQL box. i.e. two boxes shared by numerous clients. This is for an eCommerce application.We move customers to a dedicated IIS box (but still a shared SQL box) at around 100 orders per day, and a dedicated SQL box at around 250 order per day. Also they get fail-over systems at this point.Above about 3,000 orders per day we start moving them to multiple IIS / SQL boxes.Assuming around GBP 50 or US$ 100 per order, and 10% margins, then 100 orders per day is $10,000 per day and $1,000 margin, which is plenty enough to start affording some dedicated kit!However, it obviously depends on the way the application is build. (Ours, for example, has HUGE logging of all the client activity, so quite quickly you need some pretty heft SQL Server resources to cope with that)Kristen |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-26 : 22:13:39
|
>> I host my website and SQL Express for the site on the serverYou should set max memory for sql in this case, let IIS has enorgh memory to work with. |
|
|
|
|
|
|
|