sql server msde: Hello, would SQL Express 2005 be a viable solution then for a website that
uses DNS connections for a traffic of 100,000 pages downloaded per day?

Thanks Stephan

Well, do all those pages hit the database engine? If not, then what % of
the page hits results in a database request? It's 100, 000 pages per day
but how many during the peak hour? For those page hits that do hit the
database, how many database requests do they take?

A simplistic scenario: 100,000 pages per day with a peak of 10,000 pages
per hour. 50% of the pages hit the database. Each page that hits the
database requires 5 database requests. So you are generating 25,000
database requests per hour which is 7 per second. Now 7 requests per second
is not very high. A modern single processor can support 1000 requests per
second (or more depending on request complexity) so I doubt Express' limit
of a single CPU will matter. The memory limit might matter, but again I
doubt it at these modest levels of activity.

--
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com



[quoted text, click to view]