donderdag 3 oktober 2013

SQL query: hourly processed messages for BizTalk ports

One of my clients wanted to know how many messages were processed on a certain BizTalk port.
To show some statistics, I created a SQL query that lists a message count of the messages processed per hour for a certain Port.

Here's the SQL query I used:
use BizTalkDTAdb

SELECT top 200
      a.[Event/Direction],
      a.[Event/Port],
      CONVERT(VARCHAR(10), a.[Event/Timestamp], 111)   as [date],
      DATEPART(HOUR,a.[Event/Timestamp]) as [Hour],
      COUNT(*) as [Count]  
FROM [dbo].[dtav_MessageFacts] a
inner join dbo.btsv_Tracking_Parts b on a.[MessageInstance/InstanceID] = b.uidMessageID
WHERE a.[Event/Port] <> 'PortSqlMonitor'
AND a.[Event/Port] = 'BizTalkPort'
AND a.[Event/Direction] = 'Receive'
AND a.[Event/Timestamp] > DATEADD(day, -3,GETDATE())
GROUP by  a.[Event/Port], CONVERT(VARCHAR(10), a.[Event/Timestamp], 111), DATEPART(HOUR,a.[Event/Timestamp]), a.[Event/Direction]
ORDER BY CONVERT(VARCHAR(10), a.[Event/Timestamp], 111), DATEPART(HOUR,a.[Event/Timestamp])


6 opmerkingen:

  1. Thanks for sharing the code. Will try that later.



    UPS BATTERIES

    BeantwoordenVerwijderen
  2. Ultimately, this column is going to take a close look at Keto Diet. Everyone is trying to figure out a way to do that with Diet Pills. They came in first place while to be able to share an opinion on Diet Pills is enormously satisfying. Certainly Weight Loss Gummies may sound like fun but it can easily make you feel stressed out if you aren't careful. This is an appealing myth. You should ignore these beginners. Did they ever pause to guess that in connection with this? I just wish I had more wisdom in the matter of Weight Loss Gummies.

    https://www.offerplox.com/weight-loss/true-form-keto/

    https://www.offerplox.com/weight-loss/elite-keto-acv-gummies/
    https://www.offerplox.com/weight-loss/dietoxone/
    https://www.facebook.com/EliteKetoLetitiaDean
    https://www.offerplox.com/weight-loss/premium-blast-keto/
    https://www.nutraket.com/glucotru-reviews/
    https://www.nutraket.com/peak-power-cbd-gummies/
    https://www.offerplox.com/skin-care/tag-free-skin-tag-remover/

    BeantwoordenVerwijderen
  3. The SQL query to retrieve hourly processed messages is a crucial tool for monitoring system performance of port. Top Game Code It provides real-time insights into message processing rates.

    BeantwoordenVerwijderen
  4. Use Practice Exams Wisely
    Practice exams are invaluable tools for assessing your understanding and identifying weak areas that need improvement. Take advantage of these resources but remember not to rely solely on them; use them as supplements along with DP-203 exam dumps.
    Review Answer Explanations
    When practicing with sample questions or practice exams, pay close attention to the answer explanations provided after each question. These explanations offer valuable insights into why certain answers are correct or incorrect, helping you grasp concepts more effectively.
    Utilize Flashcards or Mind Maps
    To reinforce your learning, consider using flashcards or creating mind maps summarizing key information from DP-203 exam dumps. These visual aids can enhance memory retention and make revision more engaging.

    Upto 70% Discount ON THIS https://dumpsarena.com/microsoft-dumps/dp-203/

    Latest Updates Await! >>>>> DP-203 Exam Dumps

    BeantwoordenVerwijderen