Monitoring MSDE workload governor that limits 
Author Message
 Monitoring MSDE workload governor that limits
Hi,

How to monitor (how many executing,how many waiting)?

MSDE 2000 is a local data engine that can be shared. It has a managed
concurrency workload governor that limits up to five concurrent batch
workloads for optimal performance

I didn't find any suitable performance counter.



Mon, 19 Sep 2005 08:25:37 GMT
 Monitoring MSDE workload governor that limits

The only one I know of is:

DBCC CONCURRENCYVIOLATION

--
Tibor Karaszi, SQL Server MVP
For help on TSQL, please provide code we can execute in Query Analyzer

Quote:

> Hi,

> How to monitor (how many executing,how many waiting)?

> MSDE 2000 is a local data engine that can be shared. It has a managed
> concurrency workload governor that limits up to five concurrent batch
> workloads for optimal performance

> I didn't find any suitable performance counter.



Mon, 19 Sep 2005 09:27:33 GMT
 Monitoring MSDE workload governor that limits

Thanks, seems that its suits for me.



Quote:
> The only one I know of is:

> DBCC CONCURRENCYVIOLATION

> --
> Tibor Karaszi, SQL Server MVP
> For help on TSQL, please provide code we can execute in Query Analyzer




Quote:
> > Hi,

> > How to monitor (how many executing,how many waiting)?

> > MSDE 2000 is a local data engine that can be shared. It has a managed
> > concurrency workload governor that limits up to five concurrent batch
> > workloads for optimal performance

> > I didn't find any suitable performance counter.



Mon, 19 Sep 2005 09:59:35 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Monitor MSDE's 5 user limit

2. Monitoring number of batch workload

3. question about "query governor cost limit "

4. Query Governor Cost Limit Values

5. MSDE governor?

6. MSDE Governor

7. MSDE + 5 workloads + instance

8. checking workload in MSDE

9. Performance Monitor & MSDE

10. MSDE 5 user limit?

11. limit of for connections with MSDE

12. 2 gig limit on MSDE databases question


 
Powered by phpBB® Forum Software