Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2716
  • Last Modified:

URGENT.. EXPERTS PLEASE HELP...issues withSQL sever connections...

Hi Experts...

I hope I can get help here, I am approaching after doing a futile search on Internet.

The problem is:

We are having a production server with the following config:

IBM xseries 255
Ram 4gb
window 200 advance server sp3
sql server 2000 standar sp3

The website is on different system.

The SQL server was working properly and suddenly it developed a problem and started showing error messages in Logs. The error messages as seen on different logs are ...

EventLog
9/29/2004       11:09:10 AM     MSSQLSERVER     Information     -2      17055   N/A     BMDB    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.

9/29/2004       11:08:10 AM     MSSQLSERVER     Information     -2      17055   N/A     BMDB    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.

9/29/2004       11:04:37 AM     SQLSERVERAGENT  Warning Alert Engine       312     N/A     BMDB    Successfully re-opened the local eventlog - NOTE: Some events may have been missed.

9/29/2004       11:04:37 AM     SQLSERVERAGENT  Information     Alert Engine        311     N/A     BMDB    Attempting to to re-open the local eventlog...

9/29/2004       11:04:37 AM     SQLSERVERAGENT  Error   Alert Engine        318     N/A     BMDB    Unable to read local eventlog (reason: The event log file has changed between read operations).

EventViewer
Event Type:     Information
Event Source:   MSSQLSERVER
Event Category: (2)
Event ID:       17055
Date:           9/29/2004
Time:           1:20:51 PM
User:           N/A
Computer:       BMDB
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: 05 00 00 00 42 00 4d 00   ....B.M.
0010: 44 00 42 00 00 00 07 00   D.B.....
0018: 00 00 6d 00 61 00 73 00   ..m.a.s.
0020: 74 00 65 00 72 00 00 00   t.e.r...

Now, this is causing the website to slow down. It is a site accessed by more than 18k people, and average connection count is 15 at any given moment.

we even checked the number of conenctions in the connection tab of the properties of the server and the cunt is set to Zero.

Can anyone point me in right direction? Please... If we dont rectify it immediately, we will be having problem with the client. I want to give more than 500 points and will open anoter question for alloting the same. The situation is urgent

Thanks and Regards
Kiran
0
vnvk
Asked:
vnvk
  • 2
1 Solution
 
AustinSevenCommented:
I'm sure you're right that you have SQL Server Standard Edition but is that worth confirming?  

Select @@version

What does it state?   Should be .760 for SP3a I think.

Also, just a thought but how long has your SQL Server been up for?   Might be due for a restart?


AustinSeven
0
 
vnvkAuthor Commented:
It was up for almost an year. Will ask our guys at production site to check and let me know about version
0
 
vnvkAuthor Commented:
hey, I just came to know that the version is Personal Edition. I am sure that when it was isntalled and set up, we installed Standard edition, I was present onsite and now, its changed. sonmeone must ahe tampered, and nw, this is a big issue internally.

Anyway, thanks for the help. I am alloting points to you.
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now