Concurrent queries

I have an accounting program that is runing very slow. The
only error that shows in the errorlog is "spid12 This SQL
Server has been optimized for 8 concurrent queries. this
limit has been exceeded by 12 queries and performance may
be adversely affected." What dose this mean? the program
runs on SQL Server 2000.
Thaks,Daniel,
It means that you are running either MSDE or SQL2000 personal engine and
this behavior is by design.They are not meant for heavy workload and you may
want to upgrade to a retail edition.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Barnaby" <dbarnaby@.beltonschools.org> wrote in message
news:658101c37d52$ff644ee0$a601280a@.phx.gbl...
> I have an accounting program that is runing very slow. The
> only error that shows in the errorlog is "spid12 This SQL
> Server has been optimized for 8 concurrent queries. this
> limit has been exceeded by 12 queries and performance may
> be adversely affected." What dose this mean? the program
> runs on SQL Server 2000.
> Thaks,