MSDE - 5 or 8 concurrent operations 1

[Glasgow]

With regard to MSDE:

http://www.microsoft.com/sql/msde/productinfo/features.asp#H

suggests

"It has a managed concurrency workload governor that limits up to five concurrent batch workloads for optimal performance."

while

http://download.microsoft.com/download/b/3/6/b36add63-894c-4c64-a49b-6e8696932d7b/WorkLoadGov.doc

suggests:

"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."

Is there a difference between 'batch workloads' and 'operations' - if not, which is right?

Thanks in advance.

 

[nigelrivett]

The extra 3 are to allow for system threads.
It is meant to limit to 5 cucurrent user threads.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Glasgow]

OK, thanks Nigel.

Would you be able to give me a definition of thread in this context please? My app tends to open a connection and keep it open until the user has finished working with the app. Is one of my 5 threads used up for the duration of the session or just for the time it takes to open the connection (and presumably again when it fires some SQL requests to the connection)?

 

[nigelrivett]

It's when you are actually executing something.
You can have as many connections open and idle as you wish without the governor kicking in.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Glasgow]

Thanks Nigel, that sounds good. It's just that I've been apprehensive about a quote we are putting together for a 6 user system. On this basis, I think will suggest an MSDE solution.

Have a * on me.

 

[nigelrivett]

In an n-tier system which drops connections as soon as a query is executed you can limit the connection pool to 5 connections and cater for as many users as you want.

The problem comes if you have a lot of users and do go over the 5 concurrent workloads then you will end up getting worse and worse as the governor kicks in.

The other problem with msde is the database size restriction. If you are happy with that then 6 users is unlikely to be a problem.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Glasgow]

DB size restriction (2Gb?) not an issue at this stage - less that 100Mb I expect. Thanks again.