by XDK
4. July 2013 10:47
Explanation:
The default threshold is set to 30 seconds, The warning occurs when the threshold exceeds.
Log Name: Application
Source: TFS Services
Date: 1/27/2013 8:53:37 AM
Event ID: 7006
Task Category: None
Level: Warning
Detailed Message: There are no active requests for service host DefaultCollection that exceed the warning threshold of 30.
Log Name: Application
Source: TFS Services
Date: 1/27/2013 8:52:22 AM
Event ID: 7005
Task Category: None
Level: Warning
Detailed Message: A request for service host DefaultCollection has been executing for 37 seconds, exceeding the warning threshold of 30.
Solution:
Increase the threshold limit, if you experience performance issues due to these warnings. execute the following SQL statements
use [<Collection DB name>]
DECLARE @registryUpdates typ_KeyValuePairStringTableNullable
INSERT @registryUpdates ([Key], [Value])
SELECT '#\Configuration\ServiceHostMonitor\TotalExecutionElapsedThreshold\', '300'
EXEC prc_UpdateRegistry 1, 'Test', @registryUpdates, 1