I know this is an old one, but i recently searched for the answer to this in my archive, so I decided to place it here as a reminder.
Do you get the problem: every time I run HAT Query/Messages sent in pass day OR Query/Messages Received in pass day – I get the following error: The following error occurred when executing your SQL Query on the Tracking Database: Timeout Expired
Well do this:
There is a registry setting:HKEY_CURRRENT_USER\Software\Microsoft\BizTalkServer\3.0\Tracking\ConnectionTimeout
ConnectionTimeout is a dword, set it to 0 and it will never time out, you
can also set it to 100 or 500 to increase the time out so it will time out,
but after a longer period. Restart hat to have it effected.
However, there could be a larger issue here, check the size of your DTA
database. If its massive you should purge it, and trim it. It is a potential
performance issue waiting to happen. Post SP1 there was a hotfix to allow
you to do this.