Error 17052

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.htmlWhat version of SQL do you have and how many CPUs do U have configured for S
QL
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|||On Wed, 19 Nov 2003 08:21:35 -0800, "eric"
<anonymous@.discussions.microsoft.com> wrote:

>Error: 644, Severity: 21, State: 3
>Could not find the index entry for
>RID '36100101406d0610730740650720' in index page (1:257),
>index ID 0, database 'master'.
hi Eric,
we encountered the same issue on a freshly install of an
active/passive cluster Windows 2000 AS SP4 with SQLServer 2000 SP3.
the issue comes out when we try to move related cluster services from
node A to node B.
apart of fixing the master table, I'd be interested on knowing the
cause of such index curruption.
have you got any ideas?
thank you.
Francesco "Matro" Martire
available at www.realpopup.it:
RealPopup, the freeware winpopup replacer
RealAccount, freeware plugin for MS Outlook XP
MaTreo, freeware frontscreen for your Treo and PalmOS devices