Welcome to ISAserver.org

sql server concurrent queries limit exceeded?

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> sql server concurrent queries limit exceeded?

Page: [1]

Message

<< Older Topic Newer Topic >>

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

BryceS

Posts: 4
Joined: 2.Dec.2004
From: New Zealand
Status: online

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.