| Groups | Blog | Home |
sql server msde : 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.
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. __________________________________ [quoted text, click to view] "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... > > 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.shtm http://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 >
hi Mike,
"Mike" <anonymous@discussions.microsoft.com> ha scritto nel messaggio news:7be701c4771f$40cdd7e0$a401280a@phx.gbl... [quoted text, click to view] > 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.shtm http://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
Thx Andrea, Thx William,
Since u told me, I've made some test on the SQL model I have running and the queries use to take just 1/100 sec (I use to have up to 10 queries in chain per ASP page) due to the volume of the info related (this intranet wouldnt reach 100.000 records total in 38 tables, ever I think) and the easyness of the queries (it has as maximum 2 subqueries) but there is more inner joins, up to 5 in the same query, there is also 100's of relations between the tables (38 total tables). I think this information make sence to migrate the model to MSDE and use it without translating the cost of a SQL licence to my client since it wouldnt worth it. Any other sugest? Thx in advance... [quoted text, click to view] >-----Original Message-----
>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. >.
1) MSDE is free
2) JET is not intended for use in a web site for several reasons. 3) JET will outperform MSDE for some queries but it does not scale. 4) See 1. -- ____________________________________ 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. __________________________________ [quoted text, click to view] "Mike" <anonymous@discussions.microsoft.com> wrote in message news:b13701c47973$8f7843c0$a501280a@phx.gbl... > Thx Andrea, Thx William, > > Since u told me, I've made some test on the SQL model I > have running and the queries use to take just 1/100 sec (I > use to have up to 10 queries in chain per ASP page) due to > the volume of the info related (this intranet wouldnt > reach 100.000 records total in 38 tables, ever I think) > and the easyness of the queries (it has as maximum 2 > subqueries) but there is more inner joins, up to 5 in the > same query, there is also 100's of relations between the > tables (38 total tables). > > I think this information make sence to migrate the model > to MSDE and use it without translating the cost of a SQL > licence to my client since it wouldnt worth it. > > Any other sugest? > > Thx in advance... > > > > >-----Original Message----- > >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. > >. > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |