|
Home > Archive > BizTalk Server > January 2006 > BizTalkMsgboxDB SQL transactions/sec
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalkMsgboxDB SQL transactions/sec
|
|
|
| In trouble shooting a performance problem on our database cluster, I
noticed that the database BizTalkMsgboxDB has around 350
transactions/minute (6 a second) 24x7. This seems a bit excessive and
I wanted to know if there is a setting I can change to reduce the
frequency of whatever it is doing? Any help would be greatly
appreciated. Allen
| |
|
| I found the answer to this question, here is the info from our TAM, in
other words, the timerinterval is hard coded in the service.
I have spoken with someone from the BizTalk team and they have
confirmed that this number of executions is normal and would have been
occurring before you problems began also. It is not possible to alter
the frequency of this procedure.
Here is a brief summary of our telephonic discusion:
QUESTION:
[DBO].& #91;BTS_DEQUEUEMESSAGES_BIZTALKSERVERAPP
LICATION] run about 6 times
a second (350 a minute) . Is this normal?
ANSWER:
Yes. The Stored Procedure
[DBO].& #91;BTS_DEQUEUEMESSAGES_BIZTALKSERVERAPP
LICATION] runs many times a
second. There is no way to change how often this runs. You can stop
this only by stopping biztalk service.
Thanks,
Farida Bharmal
Allen wrote:
> In trouble shooting a performance problem on our database cluster, I
> noticed that the database BizTalkMsgboxDB has around 350
> transactions/minute (6 a second) 24x7. This seems a bit excessive and
> I wanted to know if there is a setting I can change to reduce the
> frequency of whatever it is doing? Any help would be greatly
> appreciated. Allen
|
|
|
|
|