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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 RAM Use

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

Posted - 2007-09-26 : 12:56:50
SQL Server will use whatever it needs and not let it go

It's suppose to work this way



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

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
Go to Top of Page

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 server

You should set max memory for sql in this case, let IIS has enorgh memory to work with.
Go to Top of Page
   

- Advertisement -