Setup the monitor service
First step is to setup the monitor service and it currently requires a SQL Server pool. Go to the connection page and create a connection to a SQL Server database in our example the connection looks like this:
Next we create a pool over the newly created connection
Go back to the service tab and create a new service of type Monitor. In the example bellow the service is called test, note that tables in the SQL Server database will get the schema test. The port to send updates is 4001 and the Website is at port 4000, the pool just created is also selected.
Create the monitor object
Start the service and select the visit link. The link open the browser to the monitor site.
Select the Object in the toolbar and login with user: admin password: admin. This page is now empty except for 2 folders named objects and processes. Select the Objects folder and right-click to create a new object. The add object page is displayed, here we call the object OrderTrack and 2 extra fields has been added 1. customer char(20) 2. tm float. Note: An object always has a type which says float in the figure bellow but is not used in this sample.
In the program that process orders we will add code to update this OrderTrack object with customer name and the time it take to process the order received.
Update the monitor object
In the order process program an XML order is received and processed like this:
We will add code to update the OrderTrack object
We have used 2 timestamp one before processing and one after to measure the processing time. The Map object is used to pass our extra fields customer and tm. The we used some components from the 360 Tracking category to send the values to the OrderTrack object.
The program above is executed through a Folder Monitor service. Each time a file is dropped in a folder the code above is executed. The customer name is retrieved from the XML.
Analyse monitor values
By double-click the OrderTrack object will display the records we have added.
Value is 0 because we didn't used that. Time is the time when the update took place. We also have the customer and time in milli-seconds it took to process the order. Next we will create a chart how processing time change over time. Select the Report tab in the toolbar and right-click the root folder and select add report. The report view is displayed
At the Basic tab the time period and type of chart is selected. Above we select only values from the last hour and we select a Line chart. At the series page one or more series can be added. One series will result in one line in the chart, Two series results in two lines e.t.c. Bellow we have selected the OrderTrack and the tm to display at the Y-axis. at the X-axis we have a dynamic timespan which will calculate how many points to display to make the chart readable.
The chart will look like this
Values from the last hour is displayed and it take approx 160 ms to process the order. In the toolbar there are options to export the values to Excel or display the chart data. It is also possible to click at a point to see the values representing that point. Clicking the lowest point bellow the 150 line show the following values:
The reason this point was lower is probably the IKEA order done in only 117 ms made the average go down