PROBLEM DESCRIPTION

We experienced an issue to where a Synchronization Cycle was being run less than every 10 minutes.  In this particular case, the Synchronization Cycle was being run every 2-3 minutes.  The Application Event Log began to fill up with Event ID 6309 with text of "Connection is busy with results for another command".   

APPLICATION EVENT LOGS

Log Name:      Application
Source:        FIMSynchronizationService
Date:          8/22/2012 11:32:11 PM
Event ID:      6309
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Description:
The server encountered an unexpected error while performing an operation for a management agent.
ERR: MMS(4744): sql.cpp(5723): Query (select count(*) from [mms_server_configuration]) performed with error
ERR: MMS(4744): sql.cpp(5776): Connection is busy with results for another command
ERR: MMS(4744): sql.cpp(5784): hrError: 0x80004005, dwMinor: 0
BAIL: MMS(4744): sql.cpp(3022): 0x80004005 (Unspecified error)
BAIL: MMS(4744): sql.cpp(4257): 0x80004005 (Unspecified error)
BAIL: MMS(4744): instimp.cpp(150): 0x80004005 (Unspecified error)
BAIL: MMS(4744): session.cpp(1328): 0x80004005 (Unspecified error)
BAIL: MMS(4744): session.cpp(2344): 0x80004005 (Unspecified error)
BAIL: MMS(4744): mastate.cpp(8656): 0x80004005 (Unspecified error)
BAIL: MMS(4744): ma.cpp(3252): 0x80004005 (Unspecified error)
Forefront Identity Manager 4.0.3627.2
 
Log Name:      Application
Source:        FIMSynchronizationService
Date:          8/22/2012 11:27:11 PM
Event ID:      6309
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Description:
The server encountered an unexpected error while performing an operation for a management agent.
ERR: MMS(4116): sql.cpp(5723): Query (select * from [mms_server_configuration] ) performed with error
ERR: MMS(4116): sql.cpp(5776): Connection is busy with results for another command
ERR: MMS(4116): sql.cpp(5784): hrError: 0x80004005, dwMinor: 0
BAIL: MMS(4116): sql.cpp(3022): 0x80004005 (Unspecified error)
BAIL: MMS(4116): sql.cpp(2794): 0x80004005 (Unspecified error)
BAIL: MMS(4116): instimp.cpp(168): 0x80004005 (Unspecified error)
BAIL: MMS(4116): session.cpp(1328): 0x80004005 (Unspecified error)
BAIL: MMS(4116): session.cpp(2344): 0x80004005 (Unspecified error)
BAIL: MMS(4116): mastate.cpp(8656): 0x80004005 (Unspecified error)
BAIL: MMS(4116): ma.cpp(3252): 0x80004005 (Unspecified error)
 

CAUSE

The reason for this is that the Synchronization Cycle running every 2-3 minutes utilizes system resources at the operating system level.  Items such as Network Ports which stay active for 2 minutes.
 

RESOLUTION

In this case, we moved the Synchronization schedule from every 2 - 3 minutes to a synchronization cycle of 10 minutes or greater.  This will reduce, if not completely resolve the issue.
 
Forefront Identity Manager 4.0.3627.2