SQL 2000 SP4 Enterprise Edition.

I have a Windows 2003 Std Edition Server Running MS SQL 2000 Enterprise Edition SP4.  I am getting the following error in the EventViewer / Application Log.

Event Type:      Information
Event Source:      MSSQLSERVER
Event Category:      Server
Event ID:      17055
Date:            5/4/2006
Time:            12:28:40 AM
User:            N/A
Computer:      NABUEPO01
Description:
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.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:
0000:  9c 42 00 00 0a 00 00 00   œB......
0008:  0a 00 00 00 4e 00 41 00   ....N.A.
0010:  42 00 55 00 45 00 50 00   B.U.E.P.
0018:  4f 00 30 00 31 00 00 00   O.0.1...
0020:  07 00 00 00 6d 00 61 00   ....m.a.
0028:  73 00 74 00 65 00 72 00   s.t.e.r.
0030:  00 00                     ..

This server is running Mcafee EPO Server.  Originally it was running MSDE SQL 4, but my DB has grown beyond the 2GB limit of MSDE and I have removed MSDE and installed the full version of SQL.  My DB being beyond the 2GB MSDE limit is another issue altogether I just want to solve these constant entries I see in the Eventviewer.

Can Anyone Help?
shanewilson6002Asked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
Start -> programs-> Microsoft SQL Server -> Quey analyser

Enter the username and password

then in the New window , paste this

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

then press F5, You can see the results in the result pane, copy that and send to me
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Usually this kind of problem comes with MSDE and MS Sql person editions, once you install the Enterprise edition, this will disappear.
I hope in enterprise edition also the problem can occur, if you have some licensing problems.

Run this to makesure that you are having the enterprise edition
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
0
 
shanewilson6002Author Commented:
Sorry I am a little anept when it comes to things like RUN.  Do you mean start Run?

Can you please give an example?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
shanewilson6002,
> Do you mean start Run?

Run in Query Analyzer  
0
 
shanewilson6002Author Commented:
Okay this is a little bit out of my SQL relm.  I need to know exactly how to do this..... PLS.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.