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.
Thursday, February 12, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment