Configure TFS event 7005 and 7006

In TFS 2012, you may see these warning events (ID 7005 and 7006) in event viewer:

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.

After you verify that your TFS server is performing well and there is no performance issues end users are really experiencing, you may want to get rid of these warnings. The default threshold is set to 30 seconds. However, it is configureable through a TFS registry key. e.g., The setting below will change the threshold to 300 seconds:

DECLARE @registryUpdates typ_KeyValuePairStringTableNullable
INSERT @registryUpdates ([Key], [Value])
SELECT '#\Configuration\ServiceHostMonitor\TotalExecutionElapsedThreshold\',
'300'

EXEC prc_UpdateRegistry 1, 'Test', @registryUpdates, 1