Enable Performance Logging

Author: Kepion Support Team

Introduction

In the Settings node of the MODELER, the Performance Log option exists to help track down performance issues in Form queries and Rule execution. Enabling the feature will log performance related information to the Kepion Database.

Example

You can then use the following query to examine the results:

SELECT * FROM [dbo].[Log]
SELECT * FROM [dbo].[LogExtension]

SELECT L.[UserID], L.[CreatedOn], L.[Duration], P.* FROM
(
  SELECT L.[LogID], [Key], [Value]
  FROM [dbo].[LogExtension] LE
  INNER JOIN [dbo].[Log] L
    ON L.LogID = LE.LogID AND L.Operation = N'Query-Form'
) LE
PIVOT(
  MAX([Value])
  FOR [Key] IN (
    [FormId],
    [Query],
    [CellCount]
  )
) AS P INNER JOIN [dbo].[Log] L
ON L.LogID = P.LogID

SELECT L.[UserID], L.[CreatedOn], L.[Duration], P.* FROM
(
  SELECT L.[LogID], [Key], [Value]
  FROM [dbo].[LogExtension] LE
  INNER JOIN [dbo].[Log] L
    ON L.LogID = LE.LogID AND L.Operation = N'Run-Rule'
) LE
PIVOT(
  MAX([Value])
  FOR [Key] IN (
    [SubmissionId],
    [RuleId],
    [Rule]
  )
) AS P INNER JOIN [dbo].[Log] L
ON L.LogID = P.LogID

Note: It may take up to 30 seconds for the results to be logged.