5-workload limit

Hi, does anyone has practical problem when exceeding the
5-workload limit of MSDE. Please tell me about it what
errors you get or how slow will performance degrade.
Maybe how you solve this. Tnx!
Hi Aldrin,
You won't get any errors when you exceed the 5-workload limit. When you
exceed this limit it will be logged in the SQL Server error log though. The
message in the error log will state that there were more than 8 concurrent
workloads, as 3 workloads have been reserved for the system to use.
Performance will drop of when you have more than 5 concurrent workloads, but
it will not be dramatically until you reach about 20 concurrent workloads as
far as I know. Of course it might be different on your system, so the best
thing you can do is test your own system with the maximum number of
workloads you expect to find out if you still get the performance you need.
You can find more information about the workload governor in the following
Knowledge Base article:
http://msdn.microsoft.com/library/?u...asp?frame=true
Jacco Schalkwijk
SQL Server MVP
"Aldrin" <aldrin@.wanadoo.nl> wrote in message
news:1bb5f01c42130$c45925a0$a301280a@.phx.gbl...
> Hi, does anyone has practical problem when exceeding the
> 5-workload limit of MSDE. Please tell me about it what
> errors you get or how slow will performance degrade.
> Maybe how you solve this. Tnx!
|||Thank you Jacco,
Now we're more sure to start with MSDE as backend (with
Delphi as frontend)! Not afraid anymore that everything
will stop or so. We will test this off course as you
wrote.
Greetings,
Aldrin

>--Original Message--
>Hi Aldrin,
>You won't get any errors when you exceed the 5-workload
limit. When you
>exceed this limit it will be logged in the SQL Server
error log though. The
>message in the error log will state that there were more
than 8 concurrent
>workloads, as 3 workloads have been reserved for the
system to use.
>Performance will drop of when you have more than 5
concurrent workloads, but
>it will not be dramatically until you reach about 20
concurrent workloads as
>far as I know. Of course it might be different on your
system, so the best
>thing you can do is test your own system with the
maximum number of
>workloads you expect to find out if you still get the
performance you need.
>You can find more information about the workload
governor in the following
>Knowledge Base article:
>
>http://msdn.microsoft.com/library/?url=/library/en-
us/architec/8_ar_sa2_0ciq.asp?frame=true[color=darkblue]
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Aldrin" <aldrin@.wanadoo.nl> wrote in message
>news:1bb5f01c42130$c45925a0$a301280a@.phx.gbl...
the
>
>.
>