Thursday, September 29, 2011

Get Performance Stats from Identity Insight

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.