MSDE for High trafic website

Could I use MSDE for a web site that has 1 million hits per day; 300,000 of
it would be database requests? Or do I have to go with MSSQL?
Thanks Stephan
Stephan, MSDE is designed to work with about 25 concurrent users before the
slowdown from the workload governor becomes noticable. MSDE is intended for
use with small workgroups.
Anything over 8 concurrent operations will cause the workload governor to
kick in, which has the effect of slowing down each transaction by a few
milliseconds. If you don't have many concurrent users, it's not a big deal,
but if you have 300,000 DB requests per day that might be a problem.
Check out this article on MSDN for further info:
http://msdn.microsoft.com/library/de...r_sa2_0ciq.asp
"Stephan" <Stephan@.discussions.microsoft.com> wrote in message
news:EF45810E-94B8-468A-ABD3-FA5403A69398@.microsoft.com...
> Could I use MSDE for a web site that has 1 million hits per day; 300,000
> of
> it would be database requests? Or do I have to go with MSSQL?
> Thanks Stephan
|||Am Wed, 19 Oct 2005 10:48:07 -0700 schrieb Stephan:

> Could I use MSDE for a web site that has 1 million hits per day; 300,000 of
> it would be database requests? Or do I have to go with MSSQL?
> Thanks Stephan
I use MSDE in a project with 20 concurrent workstations, which are polling
every 10 seconds for updates of some records, not very much. But sometimes
it happens that the workload gouvernor comes like a hammer, then it needs
from 2 up to 20 seconds before the next queries where processed. And this
is the big problem with this gouvernor, it doesn't come slow, if he starts,
he slows down the MSDE immediately very much.
But you could check SQLExpress, the "new MSDE", which has not longer such
gouvernor or other slowdowns. The limits for the new MSDE are 1 CPU, 1 Gb
Memory, no agent and so on.
But that's only what i read about it, if have not tested it in reality.
bye,
Helmut
|||Thanks! I will stick withMSSQL then.
"Chris Burnette" wrote:

> Stephan, MSDE is designed to work with about 25 concurrent users before the
> slowdown from the workload governor becomes noticable. MSDE is intended for
> use with small workgroups.
> Anything over 8 concurrent operations will cause the workload governor to
> kick in, which has the effect of slowing down each transaction by a few
> milliseconds. If you don't have many concurrent users, it's not a big deal,
> but if you have 300,000 DB requests per day that might be a problem.
> Check out this article on MSDN for further info:
> http://msdn.microsoft.com/library/de...r_sa2_0ciq.asp
> "Stephan" <Stephan@.discussions.microsoft.com> wrote in message
> news:EF45810E-94B8-468A-ABD3-FA5403A69398@.microsoft.com...
>
>