Skip to content

crowleym/MSMQ.Monitor

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Simple windows service that periodically checks messages in a given MSMQ and logs results in a local Sql CE 4.0 db.
Simple queries are used to see peaks and troughs in the queue.

i.e. 

-- queue count timeline
SELECT LogDate, COUNT(*) AS [Count]
FROM MSMQDataLogs
GROUP BY LogDate
ORDER BY LogDate

-- message time in queue
SELECT MessageID, MIN(LogDate) AS mindate, MAX(LogDate) AS maxdate, DATEDIFF(mi, MIN(LogDate), MAX(LogDate)) AS timeinqueue
FROM MSMQDataLogs
GROUP BY MessageID
ORDER BY mindate, timeinqueue

etc.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages