MSDE Performance Against Concurrent Access

Hello,
Can anybody tell me about your own experience using IIS
with MSDE as repository?
Would the concurrent access of the anonymous internet user
to the MSDE engine affect its performance if the
concurrent access reach more than 5 at a time?
Im planning to deploy an Intranet Application for
consultant office and Im affraid the MSDE to cause a
dregradation in performance if it gets more than 5
concurrent access.
Thx in Advance.
Mike.
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:7be701c4771f$40cdd7e0$a401280a@.phx.gbl...
> Hello,
> Can anybody tell me about your own experience using IIS
> with MSDE as repository?
> Would the concurrent access of the anonymous internet user
> to the MSDE engine affect its performance if the
> concurrent access reach more than 5 at a time?
> Im planning to deploy an Intranet Application for
> consultant office and Im affraid the MSDE to cause a
> dregradation in performance if it gets more than 5
> concurrent access.
> Thx in Advance.
> Mike.
you simply have to test, becouse no other project will be the same as your,
depending on the base schema, coding conventions, transactions lengths,
objects involved, data involved and so on...
usually it' said that MSDE can afford about 25 concurrent users, but this is
not a magic number, only a guess
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||As Andrea said, there is no fixed number of users. It's like asking how many
orders can a fry cook work at the same time? It's a function of how
efficiently each order is processed. How fast is the CPU? How much RAM is
available to cache the data and procedures? How fast is the hard disk? How
much data is being shipped to and from the server? How efficient is the
query or update? A single application can bring a standard edition SQL
Server to its knees if you knew what to ask for. A thousand clients an hour
might not cause the MSDE engine to kick into governor mode. It all
depends...
hth
____________________________________
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.
__________________________________
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2n21guFsegv1U1@.uni-berlin.de...
> hi Mike,
> "Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
> news:7be701c4771f$40cdd7e0$a401280a@.phx.gbl...
> you simply have to test, becouse no other project will be the same as
your,
> depending on the base schema, coding conventions, transactions lengths,
> objects involved, data involved and so on...
> usually it' said that MSDE can afford about 25 concurrent users, but this
is
> not a magic number, only a guess
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>