SQL concurrent queries?, exceeded by one

[Jim_Bruce]

My BEWS 9.1 server runs OK for a few days, maybe 2 weeks, then it will fail with the following error. When it fails, it will run VERY slow and we miss the majority of our backups. It does not fail on the same job, or the same day or any pattern we can find. It has been like this for months and we just reboot and go on. There must be a better way! Do I need to adjust some setting that will give me more concurrent queries or what?

Event Type:Information
Event Source:MSSQL$BKUPEXEC
Event Category:(2)
Event ID:17055
Date:09/01/05
Time:9:32:13 PM
User:N/A
Computer:JETSON
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.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 9c 42 00 00 0a 00 00 00 œB......
0008: 10 00 00 00 4a 00 45 00 ....J.E.
0010: 54 00 53 00 4f 00 4e 00 T.S.O.N.
0018: 5c 00 42 00 4b 00 55 00 \.B.K.U.
0020: 50 00 45 00 58 00 45 00 P.E.X.E.
0028: 43 00 00 00 07 00 00 00 C.......
0030: 6d 00 61 00 73 00 74 00 m.a.s.t.
0038: 65 00 72 00 00 00 e.r...

[Shilpa_pawar_2]

Hi,

This appears to be an issue with the MSDE 2000. Please ensure that user connections is set to "0". Please refer following steps:
1. Go to the Command Prompt.
2. Change directories to C:\Program Files\Microsoft SQL Server\80\Tools\Bin Folder on the media server.
3. Run the command: osql -S%computername%\bkupexec -E -Q sp_configure
4. Check that the "user connections" is set to 0, which is unlimited.

If above does not resolve the issue, please reapply the MSDE2000 SP3a. You may download the same from the Microsoft website.


Additional Information :
For information on the recent VERITAS Backup Exec security vulnerabilities, including links to the downloads for the necessary hotfixes, please refer to the following document:
Patch summary for Security Advisories VX05-001, VX05-002, VX05-003, VX05-005, VX05-006, VX05-007
http://seer.support.veritas.com/docs/277429.htm



http://support.veritas.com/docs/278434




NOTE : If we do not receive your reply within two business days, this post would be marked "assumed answered" and would be moved to "answered questions" pool.