sql server concurrent queries limit exceeded? (Full Version)

All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting



Message


BryceS -> sql server concurrent queries limit exceeded? (20.Feb.2008 3:56:56 PM)

Hi,

Using isa 2004 sp3 on server 2003 std ed. sp2.

This machine was setup new about 6 weeks ago.
I keep getting the following in the sql server log (number exceeded by varies):

2008-02-18 18:00:10.20 spid12    This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 101 queries and performance may be adversely affected.

It was logging errors like this since it was first set up.

Since the msde database is out of my control is this anything to concern myself with?  (Our previous machine doing this job only had isa 2004 sp1, but I think it never had errors like this).

Maybe related: I only looked in this log as VSS backups of machine were reporting errors backing up this database for the last 3 or 4 days.  Related errors in this sql log show:

2008-02-18 18:00:16.02 backup    BACKUP failed to complete the command BACKUP DATABASE [ISALOG_20080111_FWS_002] TO VIRTUAL_DEVICE='{821DB538-C9CD-4CB6-B1A5-660B826AB744}7' WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024
2008-02-18 18:00:16.15 spid71    BackupSoftFile::WriteMediaFileMark:  failure on backup device '{821DB538-C9CD-4CB6-B1A5-660B826AB744}7'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2008-02-18 18:00:16.21 spid65    BackupMedium::ReportIoError: write failure on backup device '{821DB538-C9CD-4CB6-B1A5-660B826AB744}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
2008-02-18 18:00:16.21 spid65    Internal I/O request 0x2F05FC60: Op: Write, pBuffer: 0x245B0400, Size: 1024, Position: 0, UMS: Internal: 0x0, InternalHigh: 0x0, Offset: 0x0, OffsetHigh: 0x0, m_buf: 0x00000000, m_len: 0, m_actualBytes: 0, m_errcode: 995, BackupFile: {821DB538-C9CD-4CB6-B1A5-660B826AB744}1
2008-02-18 18:00:16.24 spid66    BackupVirtualDeviceFile::PrepareToFreeze:  failure on backup device '{821DB538-C9CD-4CB6-B1A5-660B826AB744}2'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Any thoughts anyone please?

Regards,
Bryce Stenberg.





Page: [1]