• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

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]
Login
Message << Older Topic   Newer Topic >>
sql server concurrent queries limit exceeded? - 20.Feb.2008 3:56:56 PM   
BryceS

 

Posts: 6
Joined: 2.Dec.2004
From: New Zealand
Status: offline
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.

Post #: 1

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA Server 2004 Firewall] >> Logging and Reporting >> sql server concurrent queries limit exceeded? Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts