Event viewr message, Sql Performance drop down

[alexbo]

Hi all,

I have installed SQL on a server that as 5 processors, at a certain time, even if the Cpu usage is at 3% the Sql preformance drop down and the server crashes, and we have to restart it.... I've watched the event viewer and found that SQL generates the following information:
The origin contain the following insertion strings: 17052. This computer, Sql server has been optimized to run 8 queries at the same time this limit is passed. at 19 queries. this condition may influence in a negative way on the server performance.

Does anyone have any idea what I can do?

thanks in advance Alex.

 

[fluteplr]

What version of SQL Server do you have installed?

 

[alexbo]

Thanks we resolved the problem, we hav installed the Sql 2000 personal Edition instad of the standard edition... I've read in the help on dbcc concurrencyviolation and found it out.... bye Alex. thanks