Discussion Locked

SQL 2000 Server is very slow

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Our SQL 2000 Server is very slow.
When I've checked SQL log I found this message:
" This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 query and performance may be adversely affected".
I'm not the person who has configured the server. Why did it happen and what can I do to improve performance?

1 reply

by shasca

Under Administrative Tools open the Enterprise manager. Right click the SQL Server choose properties/connections Set the value to 0 ( equals unlimited )

This discussion is closed to new replies.