Event id 17055

Hello,
What is meaning of these error messages.
Event id 17055
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 2 queries and performance may be adversely affected.
AND
Event id 17055
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
best regards,It means that you are using MSDE, which has a performance throttling kicking
in when you have more
than 8 simultaneously executing queries; adding a delay for each I/O. It mig
ht be Personal Edition
as well, I don't recall whether this has throttling.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Sing" <Sing@.discussions.microsoft.com> wrote in message
news:0DD419C7-CB77-4346-9851-43CE6B088F6C@.microsoft.com...
> Hello,
> What is meaning of these error messages.
> Event id 17055
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit ha
s
> been exceeded by 2 queries and performance may be adversely affected.
> AND
> Event id 17055
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit ha
s
> been exceeded by 1 queries and performance may be adversely affected.
> best regards,
>