MSDE limitations

Hallo everybody :)
I cant make anything of MS explanation about MSDE and its limitations.
Could you please tell me, what is the matter ?
Is it true that only five paralell connections are accepted by engine ?
What abouth next ones? They are wainting in the queue ?
Thhanks in advance
regards
plutonYou can have more than 5 connections as the same time. The limitation is
when you have more than 5 queries *executing at the same time*. Then a
performance throttle will limit the throughput.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:botn03$fbp$1@.news.onet.pl...
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its limitations.
> Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine ?
> What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
>|||There are probably MSDE groups which would be a better place to ask, but I
believe MSDE is limited to 5 simultaneous queries, not 5 connections.
hth
Eric
"pluton" <zielonadupa@.poczta.onet.pl> wrote in message
news:botn03$fbp$1@.news.onet.pl...
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its limitations.
> Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine ?
> What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
>|||thanks a lot
pluton|||I think there is also a limitation on what the front-end to a MSDE database
can be written. I read somewhere -- possibly the license agreement -- that
front-ends can be written in MS products only (i.e. MS Office, .NET
Framework, etc.)|||pluton wrote:
> Hallo everybody :)
> I cant make anything of MS explanation about MSDE and its
> limitations. Could you please tell me, what is the matter ?
> Is it true that only five paralell connections are accepted by engine
> ? What abouth next ones? They are wainting in the queue ?
> Thhanks in advance
> regards
> pluton
Ignore Erics comments -Tibor is accurate
You have probably seen
http://www.microsoft.com/sql/msde/productinfo/features.asp
What is key is that it will only execute 5 concurrent batches (any
additional ones are deferred) , there is a 2Gb restriction on the size
per DB and it can only participate as a subscriber in transactional
replication scenario.
in future you might find msde specific questions better answered in
microsoft.public.sqlserver.msde
Since both products are so closely related, this newsgroup may serve to
answer your questions also.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||> Ignore Erics comments -Tibor is accurate
Ouch.
"Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in message
news:OSZoAGUqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> pluton wrote:
> > Hallo everybody :)
> >
> > I cant make anything of MS explanation about MSDE and its
> > limitations. Could you please tell me, what is the matter ?
> > Is it true that only five paralell connections are accepted by engine
> > ? What abouth next ones? They are wainting in the queue ?
> >
> > Thhanks in advance
> >
> > regards
> > pluton
> Ignore Erics comments -Tibor is accurate
> You have probably seen
> http://www.microsoft.com/sql/msde/productinfo/features.asp
> What is key is that it will only execute 5 concurrent batches (any
> additional ones are deferred) , there is a 2Gb restriction on the size
> per DB and it can only participate as a subscriber in transactional
> replication scenario.
> in future you might find msde specific questions better answered in
> microsoft.public.sqlserver.msde
> Since both products are so closely related, this newsgroup may serve to
> answer your questions also.
> --
> Br,
> Mark Broadbent
> mcdba , mcse+i
> =============|||Eric Sabine wrote:
> > Ignore Erics comments -Tibor is accurate
> Ouch.
>
> "Mark Broadbent" <no-spam-please_mark.broadbent@.virgin.net> wrote in
> message news:OSZoAGUqDHA.2584@.TK2MSFTNGP09.phx.gbl...
> > pluton wrote:
> >
> > > Hallo everybody :)
> > >
> > > I cant make anything of MS explanation about MSDE and its
> > > limitations. Could you please tell me, what is the matter ?
> > > Is it true that only five paralell connections are accepted by
> > > engine ? What abouth next ones? They are wainting in the queue ?
> > >
> > > Thhanks in advance
> > >
> > > regards
> > > pluton
> >
> > Ignore Erics comments -Tibor is accurate
> >
> > You have probably seen
> > http://www.microsoft.com/sql/msde/productinfo/features.asp
> >
> > What is key is that it will only execute 5 concurrent batches (any
> > additional ones are deferred) , there is a 2Gb restriction on the
> > size per DB and it can only participate as a subscriber in
> > transactional replication scenario.
> >
> > in future you might find msde specific questions better answered in
> > microsoft.public.sqlserver.msde
> > Since both products are so closely related, this newsgroup may
> > serve to answer your questions also.
> >
> > --
> >
> > Br,
> > Mark Broadbent
> > mcdba , mcse+i
> > =============
Sorry Eric! didnt mean to be rude just that the way I read your post it
was slightly misleading to the original question posted. Anyhow no
doubt you'll get lots of chances to get your own back since Im a long
way from infalible LOL.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============