MSDE Performance Governor - knowing when its kicked in

[Brian Cryer]

I'm working on a VB.NET project where we are intending to use MSDE as our
back-end database. The actual number of users is expected to be low and I
don't have any concerns as to whether MSDE will be up to the job (most of
the time). I'm aware that if we end up with lots of users connecting to our
site at once (which may happen as certain times in the year when people need
information for deadlines) then the performance governor in MSDE will kick
in and slow everything down.

What I don't know is how do I find out whether the performance governor has
kicked in?

I would like to know how to monitor this so we can make an educated decision
as to when we need to migrate to a full version of SQL Server (if at all).

Can anyone point me in the right direction for finding this out?

thanks,

Brian Cryer.

[Simon Hayes]

"Brian Cryer" <br****@127.0.0.1.activesol.co.uk> wrote in message
news:11***************@damia.uk.clara.net...

I'm working on a VB.NET project where we are intending to use MSDE as our
back-end database. The actual number of users is expected to be low and I
don't have any concerns as to whether MSDE will be up to the job (most of
the time). I'm aware that if we end up with lots of users connecting to
our
site at once (which may happen as certain times in the year when people
need
information for deadlines) then the performance governor in MSDE will kick
in and slow everything down.

What I don't know is how do I find out whether the performance governor
has
kicked in?

I would like to know how to monitor this so we can make an educated
decision
as to when we need to migrate to a full version of SQL Server (if at all).

Can anyone point me in the right direction for finding this out?

thanks,

Brian Cryer.

Check out DBCC CONCURRENCYVIOLATION in Books Online. If you don't already
have the latest version of BOL, then you should download it, as it has more
detailed information about MSDE and the workload governor that wasn't in
previous versions.

Simon

[Brian Cryer]

"Simon Hayes" <sq*@hayes.ch> wrote in message
news:41**********@news.bluewin.ch...

"Brian Cryer" <br****@127.0.0.1.activesol.co.uk> wrote in message
news:11***************@damia.uk.clara.net...

I'm working on a VB.NET project where we are intending to use MSDE as our back-end database. The actual number of users is expected to be low and I don't have any concerns as to whether MSDE will be up to the job (most of the time). I'm aware that if we end up with lots of users connecting to
our
site at once (which may happen as certain times in the year when people
need
information for deadlines) then the performance governor in MSDE will kick in and slow everything down.

What I don't know is how do I find out whether the performance governor
has
kicked in?

I would like to know how to monitor this so we can make an educated
decision
as to when we need to migrate to a full version of SQL Server (if at all).
Can anyone point me in the right direction for finding this out?

thanks,

Brian Cryer.
Check out DBCC CONCURRENCYVIOLATION in Books Online. If you don't already
have the latest version of BOL, then you should download it, as it has

more detailed information about MSDE and the workload governor that wasn't in
previous versions.

Simon

Excellent Simon. Just what I was after.

Many Thanks.

Brian.