If you want to see how many UMF per minute are being ingested into Identity Insight, execute the following SQL query:
SELECT TOP 100 CONVERT(SMALLDATETIME, RCV_DT), COUNT(*)
FROM RELRES..UMF_LOG WITH (NOLOCK)
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. The conversion to smalldatetime will round the RCV_DT to the nearest minute. I use the NOLOCK hint so as to minimally impact the ongoing UMF load.
