Thursday, February 12, 2009

Get JMS_messaging table trend by easy SQL

I have not find a very powerful tool (and free) to monitor the JMS_messaging table status, so i intend to write some easy SQL to monitoring the trend of it. Anyway it is just a temp solution to solve my job...

Basically the SQL is to Get the JMS_messaging table destination contents by a fixing time(like every 30 seconds or something) and meanwhile i want to get the trend of JMS_messaging table to see how many DLQs in the table before,during and after my load test.

declare @i int
declare @nowtime datetime
set @i=0

while @i<20
begin

set @nowtime=getdate()

SELECT destination, count(destination)
FROM JMS_MESSAGES
group by destination

set @i=@i+1
print @i
print convert(varchar(max), @nowtime, 121)

waitfor delay '00:00:30'

end;

so i will start this SQL just before i start my tests, then start the load test, after load test then check the results and messages in SQL server 2005.
you can adjust the loop counts(@i) and time delay value according to your load tests duration.

No comments:

Post a Comment