multiple instances of MSDE

Hello All,
Hoping someone can tell me how the 5-user governor affects multiple
instances of MSDE.
Does each instance allow unrestricted performance for up to 5 users, or
will the 6th user experience slow-down regardless of which instance db
he/she is using?
Also, with a VS.NET license, does this provide license only one instance of
MSDE, or can you install multiple?
Rein
Hi Rein,
Workload Governor in brief :
Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
MSDE 2000 allow 32,767 connections to an instance of the database engine.
There is no limit for the number of connections that can be executing
operations at the same time. The only effect of the workload governor is
that it starts slowing down the database engine when more than eight
operations are actively running at the same time.
The following link has more information on Workload Governor.
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
.asp
You can install multiple instance of MSDE, regardless of the number of
VS.NET license you have.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Ashish,
One thing I didn't understand from your response was whether the governor (I
thought it was applied after the fifth concurrent user, not after the 8th
operation) affected all instances of MSDE on a particular machine. If not,
crafty as I can be, I'm inclined to install multiple (up to 16) instances
where each instance will support an 5? ungoverned users (16x5=80 ungoverned
concurrent users!!!) Of course, 16 separate and full-fledged instances will
also probably bog the machine down, but I definately have a solution when my
application slows down due to the governor, add another instance and double
the capacity - I can make up for lost performance from running 2 identical
services by distributed partitioning...
Rein

> Workload Governor in brief :
> Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
> MSDE 2000 allow 32,767 connections to an instance of the database engine.
> There is no limit for the number of connections that can be executing
> operations at the same time. The only effect of the workload governor is
> that it starts slowing down the database engine when more than eight
> operations are actively running at the same time.
...
> You can install multiple instance of MSDE, regardless of the number of
> VS.NET license you have.
> Ashish
|||I thought it was after 5 processes running is when it starts to
slow down.
francisco
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:r9ZqpFBLEHA.3396@.cpmsftngxa10.phx.gbl...
> Hi Rein,
>
> Workload Governor in brief :
> Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
> MSDE 2000 allow 32,767 connections to an instance of the database engine.
> There is no limit for the number of connections that can be executing
> operations at the same time. The only effect of the workload governor is
> that it starts slowing down the database engine when more than eight
> operations are actively running at the same time.
>
> The following link has more information on Workload Governor.
>
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
> asp
>
> You can install multiple instance of MSDE, regardless of the number of
> VS.NET license you have.
>
> Ashish
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
|||hi Francisco,
"Francisco" <nomail@.baseball.net> ha scritto nel messaggio
news:uxN27hGLEHA.4052@.TK2MSFTNGP11.phx.gbl...
> I thought it was after 5 processes running is when it starts to
> slow down.
>
you are quite right, but the reported limit (8) includes some system related
workloads in order to grant a minimum of 5 concurrent users workloads..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Rein,
The Workload governor is affects individual instance of MSDE.
Extract from the link that I had sent in the earlier reply.
================================================== ==========================
==================================
The Microsoft SQL Server 2000 workload governor is designed to limit the
performance of an instance of the database engine any time more than eight
operations are active at the same time. An instance of the SQL Server 2000
database engine is one copy of the database software that operates as an
operating system service.
================================================== ==========================
==================================
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||You could also try the method detailed here:
http://groups.google.com/groups?selm... output=gplain
By changing a single bit in one of the MSDE files you can tell the SQL Server
to allow any number of concurrent operations without a penalty. This is
effectively a hidden switch to turn the workload governor off.