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...
>
>

MSDE Error !

Hi,
When I try to insert 7 to 8 million of rows in MSDE Rel A
version. I get the following error "Unknown token
received from SQL Server". My simulation testing was
running fine untill 4.3 million rows in a single table.
I executed sp_spaceused system stored procedure. I get
the results as follows
DATABASE :LaneDB
DATABASE SIZE: 703.50 MB
UNALLOCATED SPACE: 105.25 MB
Please help if i am missing something.
David
hi David,
"David" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1b8c01c4e1c3$2e20a460$a401280a@.phx.gbl
> Hi,
> When I try to insert 7 to 8 million of rows in MSDE Rel A
> version. I get the following error "Unknown token
> received from SQL Server". My simulation testing was
> running fine untill 4.3 million rows in a single table.
> I executed sp_spaceused system stored procedure. I get
> the results as follows
> DATABASE :LaneDB
> DATABASE SIZE: 703.50 MB
> UNALLOCATED SPACE: 105.25 MB
> Please help if i am missing something.
> David
unfortunately there are a number of conditions that can cause this. Please
do check if your process matches any of these known bugs
http://support.microsoft.com/search/...false&numDays=
&MaxResults=25&srchstep=2&InCC_hdn=true&querySourc e=gASr_Query
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply