Solved

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

Posted on 2004-09-30
3
2,702 Views
Last Modified: 2007-12-19
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
Comment
Question by:vnvk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
AustinSeven earned 500 total points
ID: 12188012
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
 
LVL 7

Author Comment

by:vnvk
ID: 12188052
It was up for almost an year. Will ask our guys at production site to check and let me know about version
0
 
LVL 7

Author Comment

by:vnvk
ID: 12188131
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

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question