June 13, 2006 at 10:51 pm
Hello again,
Recently I am getting this event log message:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 13-06-2006
Time: 3:40:15 PM
User: N/A
Computer: KHDC2K01
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 ?B......
0008: 09 00 00 00 4b 00 48 00 ....K.H.
0010: 44 00 43 00 32 00 4b 00 D.C.2.K.
0018: 30 00 31 00 00 00 07 00 0.1.....
0020: 00 00 6d 00 61 00 73 00 ..m.a.s.
0028: 74 00 65 00 72 00 00 00 t.e.r...
I am not sure what could be the cause of this message, please guide me what to do.
Thanks & Regards,
GOVIND
June 14, 2006 at 7:13 am
You have the desktop version of SQL. You will need a full version of SQL to get rid of this message. How extensive is this server being used?
June 14, 2006 at 7:36 am
Hi Steve,
I have SQL 2000 standard edition with SP3, basically its a publisher + distributor covering 3 subscribers and approx 60 clients. There is no hardware problem (its 3 Ghz xeon + 2 GB RAM IBM server). Should I still upgrade the server to Enterprise edition?
Thanks & Regards,
GOVIND
June 14, 2006 at 7:39 am
Are you sure you have the Standard edition installed? You should check the installation since I don't think I have encountered this error on anything other than the MSDE or personal edition.
If you have Standard edition you should not be encountering this problem.
June 14, 2006 at 8:01 am
Oh sorry, big mistake it is SQL 2000 Personal edition., what the fool I am. So now I have to reinstall. Thank you very much. One more thing, can I solve the problem without reinstalling the server? because it will take some time to configure the server.
Thanks again.
Govind
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply