Error 17052

I've got the following event in the event viewer of my server that run
SQL Server 2000, and it's getting stopped every 5 minutes, I don't kno
if this event and the crash have relation, if anyone know, please hel
me...
17052:
This SQL Server has been optimized for 8 concurrent queries. This limi
has been exceedec by 5 queries and performance may be adversel
affected.
Diego Modolo Ribeir
Harsmake
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message389771.htmWhat version of SQL do you have and how many CPUs do U have configured for SQL
if more than 4 what is your MAXDOP(sp_configure 'Degree') run_value?|||You are running either MSDE or Personal Edition, and these 2 versions are
optimised for a maximum of 8 concurrent queries. When you have more, the
performance of your server will drop, and you might get time outs etc. You
will have to upgrade to SQL Server Standard Edition if you want to have more
concurrent queries.
--
Jacco Schalkwijk
SQL Server MVP
"Harsmaken" <Harsmaken.11kjeo@.mail.mcse.ms> wrote in message
news:Harsmaken.11kjeo@.mail.mcse.ms...
> I've got the following event in the event viewer of my server that runs
> SQL Server 2000, and it's getting stopped every 5 minutes, I don't know
> if this event and the crash have relation, if anyone know, please help
> me...
> 17052:
> This SQL Server has been optimized for 8 concurrent queries. This limit
> has been exceedec by 5 queries and performance may be adversely
> affected.
>
> Diego Modolo Ribeiro
>
> Harsmaken
> ---
> Posted via http://www.mcse.ms
> ---
> View this thread: http://www.mcse.ms/message389771.html
>|||Thanks for clearing this up Jacco..never encountered this before