Hello,

According to the database reports, the following Forms SQL queries are consuming all of the CPU resources of the database server on a client's installation:

Number 1:

(@p__linq__0 datetime2(7))SELECT
    [Extent1].[id] AS [id],
    [Extent1].[auth_code] AS [auth_code],
    [Extent1].[tenant_id] AS [tenant_id],
    [Extent1].[user_id] AS [user_id],
    [Extent1].[ip_address] AS [ip_address],
    [Extent1].[machine] AS [machine],
    [Extent1].[last_active] AS [last_active],
    [Extent1].[session_type] AS [session_type]
    FROM [dbo].[cf_sessions] AS [Extent1]
    WHERE [Extent1].[last_active] < @p__linq__0

Number 2:

(@EntityKeyValue1 int)SELECT 
    [Extent1].[id] AS [id], 
    [Extent1].[sess_id] AS [sess_id], 
    [Extent1].[variable_name] AS [variable_name], 
    [Extent1].[variable_value] AS [variable_value]
    FROM [dbo].[cf_session_variables] AS [Extent1]
    WHERE [Extent1].[sess_id] = @EntityKeyValue1

Has someone any idea what these queries are doing, and what can be done so that the server resources are not consumed so fast?

I appreciate your help.