Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Harsmaken
Starting Member
3 Posts |
 Posted - 2004-02-13 : 07:58:48
|
| I've got the following event in the event viewer of my server that runs SQL Server 2000, and it's getting stopped every 5 minutes, I don't know if this event and the crash have relation, if anyone know, please help me...17052:This SQL Server has been optimized for 8 concurrent queries. This limit has been exceedec by 5 queries and performance may be adversely affected.Diego Modolo Ribeiro |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-13 : 08:08:00
|
| Are you sure you're not running MSDE? Run SELECT @@VERSION in a query analyzer window on that server. |
 |
|
|
Harsmaken
Starting Member
3 Posts |
Posted - 2004-02-13 : 08:19:05
|
| This is the text I got when I type the command you asked:Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 4.0 (Build 1381: Service Pack 6)It's really SQL Server, but it's personal, could this be the problem??Diego Modolo Ribeiro |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-13 : 08:30:04
|
| Yeah, that's definitely it. Doesn't help that it's running on NT 4.0 either. You'll have to upgrade SQL Server if you need to support more users. |
|
|
|
Harsmaken
Starting Member
3 Posts |
Posted - 2004-02-13 : 08:32:29
|
| thanks, I'll do it...Diego Modolo Ribeiro |
|
|
|
|
|
|
Error 17052