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 Limits

I know from experience that when the number of concurrent users on an MSDE
database exceeds the limit, an error is logged and the workload govenor
kicks in. Does something similar occur when the 2 GB limit is exceeded? I
had the experience yesterday where an application stopped responding for no
apparent reason. It's MSDE database was near 2 GB and the only thing we
could figure was that MSDE was trying to extend the database past 2GB.
Unfortunately there was no error logged, either from MSDE or from my
application.
MSDE will not allow you to extend the size of the database beyond 2GB. There
is no limit on the size of the log file, but there will be an inherent limit
on insert transactions due to the limit on the database size. If your
database has reached 2GB you should still be able to query data or perform
deletes or updates (as long as the update don't tigger an extent). If MSDE
failed to create an extent then there should be an log entry created in the
SQL Server log.
Jim
"Andy Walldorff" <andyw@.REMOVEsuperior.net> wrote in message
news:OfI6oIJHEHA.3288@.TK2MSFTNGP12.phx.gbl...
> I know from experience that when the number of concurrent users on an MSDE
> database exceeds the limit, an error is logged and the workload govenor
> kicks in. Does something similar occur when the 2 GB limit is exceeded?
I
> had the experience yesterday where an application stopped responding for
no
> apparent reason. It's MSDE database was near 2 GB and the only thing we
> could figure was that MSDE was trying to extend the database past 2GB.
> Unfortunately there was no error logged, either from MSDE or from my
> application.
>
|||Thanks
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:uxhZEINHEHA.4092@.TK2MSFTNGP11.phx.gbl...
> MSDE will not allow you to extend the size of the database beyond 2GB.
There
> is no limit on the size of the log file, but there will be an inherent
limit
> on insert transactions due to the limit on the database size. If your
> database has reached 2GB you should still be able to query data or perform
> deletes or updates (as long as the update don't tigger an extent). If MSDE
> failed to create an extent then there should be an log entry created in
the
> SQL Server log.
> Jim
> "Andy Walldorff" <andyw@.REMOVEsuperior.net> wrote in message
> news:OfI6oIJHEHA.3288@.TK2MSFTNGP12.phx.gbl...
MSDE
> I
> no
>

MSDE for Testing, SQL Server for Deployment...?

I'm going to be starting a web application this week. I have quite a bit of experience with Access Databases, and I've also used MySQL (back in my PHP days, thank GOD for ASP.NET).
The server we use to host our websites allows us to use SQL Server databases, so I want to move in that direction, but I'm not really sure where to start.
If I download MSDE, and start a database with it on a site I will be developing locally (on my XP box), will it be difficult for me to transfer the database (or layout of the database) to a production server running SQL Server. I know they're basically the same database, but I'm just afraid to start with an MSDE database and then get the site nearly complete, and then not know how to transfer it to a SQL Server DB.

I'm particularly interested to know if the majority of the database creation will be done through queries (similar to MySQL) because I figure if it is, then I can use the same queries to create the database on both the local and production server.

I just want to make sure that downloading MSDE will be a step in the right direction.

Perhaps links or tutorials or some information on things to watch out for as I take on this process would be so greatly appreciated.

Thanks very much.The same code that works on MSDE will work fine on SQL Server. You can use queries to create tables/views/stored procedures, or you can use Enterprise Manager or Visual Studio .NET (presuming you have the correct version - I am not sure what version is required of VS.NET to do DB work).|||Thanks for your reply douglas.reilly
Now if I am creating with queries, what's the best way to go about doing that exactly? Should I create a page that executes the query I type into a textbox? Or is there a better (probably more secure and reliable) way of doing it?

Thanks again for your help!