Get Performance Stats from Identity Insight

If you want to see how many UMF messages are being processed per minute, execute one of the following SQL queries:

Oracle
SELECT DT, C
FROM (SELECT TO_CHAR(RCV_DT, 'YYYY-MM-DD HH24:MI') DT, COUNT(*) C
      FROM UMF_LOG
      WHERE RCV_DT >= DATE '2014-12-15'
      GROUP BY TO_CHAR(RCV_DT, 'YYYY-MM-DD HH24:MI')
      ORDER BY TO_CHAR(RCV_DT, 'YYYY-MM-DD HH24:MI') DESC)
WHERE ROWNUM <= 100;

SQL Server
SELECT TOP 100 CONVERT(SMALLDATETIME, RCV_DT) DT, COUNT(*) C
FROM UMF_LOG WITH (NOLOCK)
WHERE RCV_DT >= '2014-12-15'
GROUP BY CONVERT(SMALLDATETIME, RCV_DT)
ORDER BY CONVERT(SMALLDATETIME, RCV_DT) DESC

This will return a count of records processed for the last 100 minutes.  Substitute in the current date for 2014-12-15 to limit the number of rows processed.

In the SQL Server query, the conversion to smalldatetime will round the RCV_DT to the nearest minute.  I use the NOLOCK hint so as to minimally impact any ongoing UMF load.