How to Change the Query Timeout Value in Health and Activity Tracking
How to Change the Query Timeout Value in Health and Activity Tracking

By default, Health and Activity Tracking (HAT) will time out if a query runs longer than 60 seconds. You can change the timeout value in the registry to enable queries to run longer than 60 seconds.

Aa578005.Caution(en-us,BTS.20).gifCaution
Incorrectly editing the registry may severely damage your system. Before making changes to the registry, you should back up any valued data on the computer.

Prerequisites

You must be logged on as a member of the Administrators group to perform this procedure.

To change the query timeout value in Health and Activity Tracking

  1. Click Start, click Run, type regedit, and then click OK.

  2. In Registry Editor, locate and then click the following subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0

  3. If there is a Tracking subkey, go to step 6.

  4. To create a Tracking subkey, on the Edit menu, point to New, and then click Key.

  5. Type Tracking, and then press ENTER.

  6. Locate and then click the following subkey:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0\Tracking

  7. On the Edit menu, point to New, and then click DWORD Value.

  8. Type ConnectionTimeout, and then press ENTER.

  9. Right-click ConnectionTimeout, and then click Modify.

  10. In the Edit DWORD Value dialog box, click Decimal.

  11. In the Value data box, type the value in seconds that you want to set for the query timeout value, and then click OK.

  12. On the File menu, click Exit.

  13. Close and then reopen HAT in order for the new timeout value to take effect.

See Also

Other Resources

Using Health and Activity Tracking

© 2009 Microsoft Corporation. All rights reserved.   Terms of Use | Trademarks | Privacy Statement
Page view tracker
Rate the Lightweight library
x
Lightweight builds on ScriptFree (loband) by adding features you've requested: a SearchBox and default code language selection.
Do you like the SearchBox?
Do you like the tabbed code blocks?
How useful is this topic?
Tell us more.
Thanks
x
You're helping to improve MSDN Online.
Feedback
Switch View
Classic
Lightweight Beta
ScriptFree
Switch View