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
>

MSDE Licensing In Web App?

I have an ASP.NET web application that will be accessed from the Internet.
Does the MSDE redistributable license cover this situation?
Thanks,
<WARNING: I'm not a lawyer>
Yes. It's commonly used that way. The biggest limitation is usually the
database size limit if you make good use of connection pooling.
</WARNING: I'm not a lawyer>
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Hani Atassi" <hani@.community.nospam> wrote in message
news:89E6E948-F597-41DF-9F8A-61F0DBC2177D@.microsoft.com...
>I have an ASP.NET web application that will be accessed from the Internet.
> Does the MSDE redistributable license cover this situation?
> Thanks,
|||you may also need a Windows Server External Connector License.
If you are running on Windows Server and the external connections are not
from employees, then you need the EC. If they are employees, then you need
CALs for those employees.
-Dino
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:eSlqRs9xEHA.3840@.tk2msftngp13.phx.gbl...
> <WARNING: I'm not a lawyer>
> Yes. It's commonly used that way. The biggest limitation is usually the
> database size limit if you make good use of connection pooling.
> </WARNING: I'm not a lawyer>
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Hani Atassi" <hani@.community.nospam> wrote in message
> news:89E6E948-F597-41DF-9F8A-61F0DBC2177D@.microsoft.com...
>

MSDE Installation failure

Hi,
I've downloaded MSDE 2000 R1 from Internet. Tried to install on my PC with
running on Windows XP Pro with SP2.
When everytime i runned the Setup.exe, it will prompt for "A Strong SA
password is required for security reasons. Please use SAPWD switch to supply
the same. Refer to readme for more details. Setup will now exit".
Everyone know about this ? anyway to proceed the installation ?
Thank you
You need to either supply commandline arguments, or edit the empty
setup.ini file and supply them as options there. Go to
msdn.microsoft.com and search for articles like: installing MSDE.
-nick
On Tue, 3 May 2005 01:08:05 -0700, "CK" <CK@.discussions.microsoft.com>
wrote:

>Hi,
>I've downloaded MSDE 2000 R1 from Internet. Tried to install on my PC with
>running on Windows XP Pro with SP2.
>When everytime i runned the Setup.exe, it will prompt for "A Strong SA
>password is required for security reasons. Please use SAPWD switch to supply
>the same. Refer to readme for more details. Setup will now exit".
>Everyone know about this ? anyway to proceed the installation ?
>Thank you
|||hi,
CK wrote:
> Hi,
> I've downloaded MSDE 2000 R1 from Internet. Tried to install on my PC
> with running on Windows XP Pro with SP2.
> When everytime i runned the Setup.exe, it will prompt for "A Strong SA
> password is required for security reasons. Please use SAPWD switch to
> supply the same. Refer to readme for more details. Setup will now
> exit".
> Everyone know about this ? anyway to proceed the installation ?
> Thank you
please have a look at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
for all setup parameter...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE EULA licensing

Can I use MSDE 2000 (Release A) for websites public on Internet ?
In EULA I found: "for your internal use" .. then NO ?
[EULA (license.txt)]
1.1 General License Grant. Microsoft grants to you for your internal
use a nonexclusive, limited, royalty free license to install and use the
Software.
Thanks.
Maurizio
hi Maurizio,
Maurizio Sanguinetti wrote:
> Can I use MSDE 2000 (Release A) for websites public on Internet ?
> In EULA I found: "for your internal use" .. then NO ?
> [EULA (license.txt)]
> 1.1 General License Grant. Microsoft grants to you for your
> internal use a nonexclusive, limited, royalty free license to install
> and use the Software.
AFAIK, MSDE Rel A is free to install and use, for internal as long as for
web scenarios usage..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply