MSDE Release A max number of concurrent queries

Hi All. A friend of mine mentioned that Release A actually has the max number
of concurrent queries to be 25 instead of 7 as MSDE. Is this true? Thank you
hi Andrew,
Andrew @. Abaki wrote:
> Hi All. A friend of mine mentioned that Release A actually has the
> max number of concurrent queries to be 25 instead of 7 as MSDE. Is
> this true? Thank you
false.. MSDE (and there's only one of it, only different packages with
different eulas) allows up to 8 concurrent (of the ones included in the
count of the Governor it self) batches before the Governor Workload kicking
in ...
http://msdn.microsoft.com/library/?u...asp?frame=true
25 is a "magic number" guessed by Microsoft,
http://www.microsoft.com/sql/msde/ho.../msdeuse.mspx, at the question
Q. Can I use MSDE as a database for Web applications?
A. Yes, MSDE is an ideal solution for basic Web applications with up to 25
concurrent users.
this number obviously depends on the application code quality, access type,
data nature and design, activities on it, ...
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
|||The confusion comes from "concurrent queries" versus "concurrent users".
The workload governor operates off the former while users are typically
looking to configure based on the latter.
The workload governor allows essentially 480 (sub-second) database queries
or other (e.g., update) operations per minute without degradation. You can
ballpark what this means in terms of transactions. Assume a simple
transaction has perhaps 5 queries. A mid-level has perhaps 20, and a
complex transaction has about 40. So you can support between 10 and 100
transactions per minute with MSDE with no degradation. OLTP leans towards
the simple side (volume-wise you might have 70-80% of your transactions in
the simple category) so lets assume 75 transactions per minute.
The real question for MSDE thus is, how many users does it take to generate
75 transactions in a minute. If your users submit one transaction per
minute then you could support 75 users. If your users submit 2-3
transactions per minute then you get to the 25 users that Microsoft targets
as a maximum. If your workload leans towards the more complex transactions
then the numbers you support go down. If users do very infrequent
transactions then the numbers go up.
Microsoft's real target for MSDE was for apps that support 10 users or less.
There is a lot of history there in terms of the business target and the
technical requirements. One part of the requirements analysis dictated that
hard concurrent user limits cause major customer dissatisfaction. So MSDE
was not given a hard concurrent user limit nor was the governor set to make
performance fall off a cliff after 10 users. The result is that for many
applications MSDE supports far larger numbers of users than the technical
specs might indicate.
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3sbpn3Fn11hqU1@.individual.net...
> hi Andrew,
> Andrew @. Abaki wrote:
> false.. MSDE (and there's only one of it, only different packages with
> different eulas) allows up to 8 concurrent (of the ones included in the
> count of the Governor it self) batches before the Governor Workload
> kicking in ...
> http://msdn.microsoft.com/library/?u...asp?frame=true
> 25 is a "magic number" guessed by Microsoft,
> http://www.microsoft.com/sql/msde/ho.../msdeuse.mspx, at the question
> Q. Can I use MSDE as a database for Web applications?
> A. Yes, MSDE is an ideal solution for basic Web applications with up to 25
> concurrent users.
> this number obviously depends on the application code quality, access
> type, data nature and design, activities on it, ...
> --
> 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
>
|||And, BTW, this is an oversimplification. Most queries take a tiny fraction
of a second. So you could really support quite a bit more than I show. But
my example allows for some decent conservative planning.
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"Hal Berenson" <hberenson@.predictableit.com> wrote in message
news:u9qGL4x2FHA.632@.TK2MSFTNGP10.phx.gbl...
> The confusion comes from "concurrent queries" versus "concurrent users".
> The workload governor operates off the former while users are typically
> looking to configure based on the latter.
> The workload governor allows essentially 480 (sub-second) database queries
> or other (e.g., update) operations per minute without degradation. You
> can ballpark what this means in terms of transactions. Assume a simple
> transaction has perhaps 5 queries. A mid-level has perhaps 20, and a
> complex transaction has about 40. So you can support between 10 and 100
> transactions per minute with MSDE with no degradation. OLTP leans towards
> the simple side (volume-wise you might have 70-80% of your transactions in
> the simple category) so lets assume 75 transactions per minute.
> The real question for MSDE thus is, how many users does it take to
> generate 75 transactions in a minute. If your users submit one
> transaction per minute then you could support 75 users. If your users
> submit 2-3 transactions per minute then you get to the 25 users that
> Microsoft targets as a maximum. If your workload leans towards the more
> complex transactions then the numbers you support go down. If users do
> very infrequent transactions then the numbers go up.
> Microsoft's real target for MSDE was for apps that support 10 users or
> less. There is a lot of history there in terms of the business target and
> the technical requirements. One part of the requirements analysis
> dictated that hard concurrent user limits cause major customer
> dissatisfaction. So MSDE was not given a hard concurrent user limit nor
> was the governor set to make performance fall off a cliff after 10 users.
> The result is that for many applications MSDE supports far larger numbers
> of users than the technical specs might indicate.
> Hal Berenson, President
> PredictableIT, LLC
> www.predictableit.com
>
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3sbpn3Fn11hqU1@.individual.net...
>

MSDE Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very much
No, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much
sql

MSDE Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very muchNo, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much|||Thank you very much. This answers my question

MSDE Release A

Dear Experts,
I heard that MSDE Release A removes the limitation of 7 concurrent
queries that affect MSDE when too many users connecting to the system at
the same time. Is this correct?
Thank you very muchNo, Release A does not make any changes to the Query Governor. You are
probably confusing this with SQL Server 2005 Express Edition which replaces
MSDE. Express does not have a Query Governor.
--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com
"Huy (Andrew) V Nguyen" <andrew.nv@.gmail.com> wrote in message
news:OspP3bHVGHA.5332@.TK2MSFTNGP10.phx.gbl...
> Dear Experts,
> I heard that MSDE Release A removes the limitation of 7 concurrent queries
> that affect MSDE when too many users connecting to the system at the same
> time. Is this correct?
> Thank you very much|||Thank you very much. This answers my question

MSDE Installation via Terminal Services

I'm seeing some conflicting information and wanted to try to get it
clarified. The original release of MSDE 2000 couldn't be installed from a
Terminal Services session on a TS in Application Mode. The release notes
for MSDE 2000 Release A (which contains SP3A) still mention that there could
be problems installing via Terminal Services. But KB artcle 317268 says
that you can install SP2 via Terminal Services.
So the obvious question is, can I install MSDE 2000 Release A from a W2K3
Terminal Services session while in Application Mode?
Hal Berenson, President
PredictableIT, LLC
hi Hal,
Hal Berenson wrote:
> I'm seeing some conflicting information and wanted to try to get it
> clarified. The original release of MSDE 2000 couldn't be installed
> from a Terminal Services session on a TS in Application Mode. The
> release notes for MSDE 2000 Release A (which contains SP3A) still
> mention that there could be problems installing via Terminal
> Services. But KB artcle 317268 says that you can install SP2 via
> Terminal Services.
> So the obvious question is, can I install MSDE 2000 Release A from a
> W2K3 Terminal Services session while in Application Mode?
nope, AFAIK, but never tested sp4.. I "consolidated" the original
"impossibility" :D
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

MSDE Install rolls back - not same as other posts

Windows Server 2003 with SP1.
I'm trying to install MSDE Release A (no previous installations of MSDE
exist on this server). Just before the "Please wait while Windows configures
Microsoft SQL Server Desktop Engine" finishes, the 'Cancel' button disappears
and the installation rolls back. No error message.
I ran setup through a command line with the logging parameter: setup.exe
/L*v "c:\msdelog.log" and found a 'Return Value 3' (the surrounding contents
shown below):
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (PEREZ2006,LocalSystem,87).
Action ended 13:05:25: InstallFinalize. Return value 3.
In addition, the following event appears in the Application Event Viewer:
Event Type:Information
Event Source:MsiInstaller
Event Category:None
Event ID:11708
Date:10/2/2006
Time:1:37:27 PM
User:PEREZDESIGN\Administrator
Computer:PEREZ2006
Description:
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 45 30 39 42 34 38 42 {E09B48B
0008: 35 2d 45 31 34 31 2d 34 5-E141-4
0010: 32 37 41 2d 41 42 30 43 27A-AB0C
0018: 2d 44 33 36 30 35 31 32 -D360512
0020: 37 32 32 34 41 7d 7224A}
I have confirmed that the antivirus is disabled, file & printer sharing is
enabled, and the Server service is running. I am logged in as a domain Admin.
Any help is greatly appreciated!
aguilab@.networkinnovations.us
Brian Aguila
hi Brian,
Brian Aguila wrote:
>..
> I ran setup through a command line with the logging parameter:
> setup.exe /L*v "c:\msdelog.log" and found a 'Return Value 3' (the
> surrounding contents shown below):
> --
> Starting custom action InstallSQLAgentSecurity
> InstallSQLAgentSecurity failed (PEREZ2006,LocalSystem,87).
> Action ended 13:05:25: InstallFinalize. Return value 3.
> ...
> I have confirmed that the antivirus is disabled, file & printer
> sharing is enabled, and the Server service is running. I am logged
> in as a domain Admin.
are you perhaps installing MSDE in Terminal Server Application mode?
http://support.microsoft.com/default...b;en-us;317268
http://support.microsoft.com/default...b;EN-US;238162
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
|||No, ma'am, this server is not running in terminal services application mode.
"Andrea Montanari" wrote:

> hi Brian,
> Brian Aguila wrote:
> are you perhaps installing MSDE in Terminal Server Application mode?
> http://support.microsoft.com/default...b;en-us;317268
> http://support.microsoft.com/default...b;EN-US;238162
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||hi Brian,
Brian Aguila wrote:
> No, ma'am,
sir ;D

> this server is not running in terminal services
> application mode.
try having a look at
http://www.experts-exchange.com/Data..._21114173.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

MSDE install

Dear Everybody,
When i am installing MSDE 2000 Release A on Windows XP Professional System.
It gives me Error "Invalid Instance Name".
What I done wrong please help me.
Ashok
hi,
Ashok wrote:
> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional
> System. It gives me Error "Invalid Instance Name".
>
can you please provide the command line you passed to the setup.exe boostrap
installer?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 BLANKSAPWD=1
Here the instance name is NetSDK.
Once you are instlled successful with this instance name NetSDK, if you want
to install again with the same instance name, you need to remove instance.
"Ashok" wrote:

> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional System.
> It gives me Error "Invalid Instance Name".
> What I done wrong please help me.
> Ashok
>
>

MSDE Inatallation

Hi,
I downloaded the MSDE release A (MSDE2000A.exe) from below mentioned link.
http://www.microsoft.com/downloads/d...displaylang=en
Extracted the MSDE2000A.exe to local directory (C:\MSDERelA).
Through Command Prompt executed the following command:
setup SAPWD="sa" INSTANCENAME="Testdb" TARGETDIR="C:\MSDERelA" /L*v
"C:/MSDELog.log"
The following message is popedup:
"Please go to control panel to install adn configure system components"
if click ok, setup is aborted.
Note: My system have Windows XP operating system with Service pack 1
please help to properly install MSDE with the setup downloaded.
Regards,
Abdul Saleem
hi Abdhul,
Abdhul Saleem wrote:
> Hi,
> I downloaded the MSDE release A (MSDE2000A.exe) from below mentioned
> link.
> http://www.microsoft.com/downloads/d...displaylang=en
> Extracted the MSDE2000A.exe to local directory (C:\MSDERelA).
> Through Command Prompt executed the following command:
> setup SAPWD="sa" INSTANCENAME="Testdb" TARGETDIR="C:\MSDERelA" /L*v
> "C:/MSDELog.log"
> The following message is popedup:
> "Please go to control panel to install adn configure system
> components" if click ok, setup is aborted.
> Note: My system have Windows XP operating system with Service pack 1
> please help to properly install MSDE with the setup downloaded.
> Regards,
> Abdul Saleem
please verify File & Printer Sharing is enabled, the Server service up and
running too..
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

MSDE icon not in systray

Hi,
I've just reinstalled MSDE release A on my machine. When I boot up the icon
in the systray is not there but it shows that it is running in task manager
does anyone know why tis is happening at what I can do to have the icon back
in the systray?
Thanks
hi,
"bcb963" <bcb963@.discussions.microsoft.com> ha scritto nel messaggio
news:497190C5-F881-45A8-9A10-2709126CB18E@.microsoft.com
> Hi,
> I've just reinstalled MSDE release A on my machine. When I boot up
> the icon in the systray is not there but it shows that it is running
> in task manager does anyone know why tis is happening at what I can
> do to have the icon back in the systray?
> Thanks
in the Starup folder, create a link pointing to
"C:\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE fails to install; cnfgsvr cannot start the instance service.

Windows XP, SP2; MSDE 2000 Release A - on some installs of the XP SP2 MSDE installation fails, the section of the install log that applies is:

Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INSTANCE" -Q "SQL_Latin1_General_CP1_CI_AS""
MSI (c) (60:64) [19:21:20:734]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg

Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
MSI (s) (B4!F4) [19:21:33:546]: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.

Action ended 19:21:33: InstallFinalize. Return value 3.

Examining cnfgsvr.out yields:

###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

###############################################################################

Manually starting the service and then running cnfgsvr from a command window correctly configures the server.

Does anyone have any hints as to why cnfgsvr is not able to start the service? I would like to figure out what on the machine is causing the MSDE install to fail.Nothing?|||I have the exact same problem :(|||This problem is difficult to detect and is likely caused by mixed up MDAC product stack. Please try upgrading to latest MDAC and retry.

MSDE fails to install; cnfgsvr cannot start the instance service.

Windows XP, SP2; MSDE 2000 Release A - on some installs of the XP SP2 MSDE installation fails, the section of the install log that applies is:

Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INSTANCE" -Q "SQL_Latin1_General_CP1_CI_AS""
MSI (c) (60:64) [19:21:20:734]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg

Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
MSI (s) (B4!F4) [19:21:33:546]: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.

Action ended 19:21:33: InstallFinalize. Return value 3.

Examining cnfgsvr.out yields:

###############################################################################

Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
###############################################################################

Manually starting the service and then running cnfgsvr from a command window correctly configures the server.

Does anyone have any hints as to why cnfgsvr is not able to start the service? I would like to figure out what on the machine is causing the MSDE install to fail.
Nothing?|||I have the exact same problem :(
|||This problem is difficult to detect and is likely caused by mixed up MDAC product stack. Please try upgrading to latest MDAC and retry.

MSDE fails to install; cnfgsvr cannot start the instance service.

Windows XP, SP2; MSDE 2000 Release A - on some installs of the XP SP2 MSDE installation fails, the section of the install log that applies is:

Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INSTANCE" -Q "SQL_Latin1_General_CP1_CI_AS""
MSI (c) (60:64) [19:21:20:734]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg

Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
MSI (s) (B4!F4) [19:21:33:546]: Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.

Action ended 19:21:33: InstallFinalize. Return value 3.

Examining cnfgsvr.out yields:

###############################################################################

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1460)

SQL Server configuration failed.

###############################################################################

Manually starting the service and then running cnfgsvr from a command window correctly configures the server.

Does anyone have any hints as to why cnfgsvr is not able to start the service? I would like to figure out what on the machine is causing the MSDE install to fail.Nothing?|||I have the exact same problem :(|||This problem is difficult to detect and is likely caused by mixed up MDAC product stack. Please try upgrading to latest MDAC and retry.

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