By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

MSDE Performance Governor - knowing when its kicked in

P: n/a
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.
Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"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
Jul 23 '05 #2

P: n/a
"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.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.