How many concurrent user of msde

i want to know how many user can access to msde in same
time?
Depends what you mean at the "same time". MSDE can handle numerous
connections. Your connection limit is limited by your particular licensing
and how much RAM you have on the workstation. Remember each connection to
MSDE take 40KB of RAM even though you are doing work with the connection or
not.
Up to 8 concurrent worker threads can access SQL Server at one time.
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
|||It's really more involved than simply "8 concurrent worker threads". MSDE is
not limited based on the number of connections--it's governed on how much
work it's asked to do at one time. Each operation (query/batch) consumes at
least one worker thread. These operations typically take a few milliseconds
to several minutes to run (depending on how you write the query). You can
execute 8 of these simultaneously without penalty--MSDE processes them as
quickly as the (single) processor allows. Once you ask for more than 8, the
governor kicks in and slows down all 8 by a fixed factor. When you ask for
more work from MSDE, it slows everything down even more--by a factor of the
number of worker threads over 8.
If you're clever, you can easily support many dozens of users and never see
the governor kick in.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Thomas Carey, r." <tcarey@.Online.microsoft.com> wrote in message
news:76QIHt$kEHA.2792@.cpmsftngxa10.phx.gbl...
> Depends what you mean at the "same time". MSDE can handle numerous
> connections. Your connection limit is limited by your particular
> licensing
> and how much RAM you have on the workstation. Remember each connection to
> MSDE take 40KB of RAM even though you are doing work with the connection
> or
> not.
> Up to 8 concurrent worker threads can access SQL Server at one time.
> Please reply only to the newsgroup so that others can benefit. When
> posting,
> please state the version of SQL Server being used and the error
> number/exact
> error message text received, if any.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>