- This topic has 2 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
-
hi
first of all i thank you for the reply nishil
let me be more descriptive on what i require. for e.g if you have an interface which as an Receive port A and do some Buziness processing (either using orchestration or not even using orchestration) and give the output to Send port B and one more Send port C to some other systems.
The count i require is to be 3 that is 1 input to the hub and two output as spike(hub and spoke model).so at an end of the spcific period if i run the query i should get total count based on the above logic.(i dont know whether this can be achieved at a single stroke)
so am looking in to the Database to find out which table in the biztalk databases can provide me such type of count.
The solution which you provide wont work it there is no orchestration at all for some interface.can you pleas suggest me any thing on the subscription tables or any other way to obtain the neccessary output.
Thanks once again for you esteemed help,expecting the same
-
Count of all Orchestration instances grouped by state
What it does: Gives statistical information about all orchestration instances in your system and groups them into the different states they might be in. This type of information is available in the admin MMC by right clicking on an orchestration and selecting properties. This is just a way to rollup all data across all orchestration types and to do it programmatically.
How to read the results: If you have a large number of suspended instances well then something is failing. If you have a large number of dehydrated instances it could indicate a problem with your backend systems not responding promptly or it could just mean that the host in which messaging services are running is not up. If you have a large number of Ready To Run services then either your server is not up or you have a lot of load on your system and are trying hard to keep up. Might not be a problem if we catch up later, but if we can’t catch up then your system is being over driven.
What to do: If they are suspended, you need to look at the suspended info in HAT and determine why they are suspended and do something about. If they are dehydrated and you are concerned, you should look at the message flow to see what they are waiting for and then determine why that message has not come back. If they are ready to run, you should make sure your services are running and then check CPU utilization on these machines and other resource issues because they might be over-driven.
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET DEADLOCK_PRIORITY LOWSELECT o.nvcName AS Orchestration, COUNT(*) as Count,
CASE i.nState
WHEN 1 THEN ‘Ready To Run’WHEN 2 THEN ‘Active’
WHEN 4 THEN ‘Suspended Resumable’
WHEN 8 THEN ‘Dehydrated’
WHEN 16 THEN ‘Completed With Discarded Messages’
WHEN 32 THEN ‘Suspended Non-Resumable’
END as StateFROM [BizTalkMsgboxDb]..[Instances] AS i WITH (NOLOCK)
JOIN [BizTalkMgmtDb]..[bts_Orchestration] AS o WITH (NOLOCK) ON i.uidServiceID = o.uidGUID
–WHERE dtCreated > ‘2004-08-24 00:00:00’ AND dtCreated < ‘2004-08-24 13:30:00’
GROUP BY o.nvcName, i.nState
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.