Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2004-09-30
3
Medium Priority
?
2,711 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 1500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

719 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