Solved

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

Posted on 2004-09-30
3
2,679 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
  • 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
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…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now