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?