Resolution | - Run the following SQL command to get session id from a list of users logged into Archer.
SELECT s.sessionId, s.userId AS UserId, lc.user_domain AS Domain, u.user_username AS UserName, u.user_display_name AS DisplayName , uv.xuserconttype_value AS DefaultEmail , ut.user_type_name AS UserType , uv.sec_prm_name AS SecurityParameter , CONVERT(varchar,(GETUTCDATE() - s.create_date),108) AS TimeIn , CONVERT(varchar,(GETUTCDATE() - s.session_Timestamp),108) AS TimeIdle , CAST(CASE WHEN GETUTCDATE() > s.session_Expires THEN 'Expired' ELSE CONVERT(varchar,(s.session_Expires - GETUTCDATE()),108) END AS varchar) AS TimeLeft , s.create_date AS LoginTime, s.session_Timestamp AS LastActivity, s.session_Expires AS Expires , uv.logged_in AS IsLoggedIn, s.is_impersonated AS IsImpersonated FROM tblSession s WITH ( NOLOCK ) LEFT JOIN tblUser u ON u.user_id = s.userId LEFT JOIN viewUserList uv WITH ( NOLOCK ) ON uv.user_id = s.userId LEFT JOIN tblUserType ut WITH ( NOLOCK ) ON ut.user_type_id = u.user_type_id LEFT JOIN tblLdapConfig lc WITH(NOLOCK) ON lc.config_id = u.ldap_config_id WHERE uv.logged_in = 1 AND uv.is_impersonated = 0 AND u.user_type_id IN (1,3) 
Copy the sessionId from results. From SQL Management Studio, open SQL Server Profiler. From the Events Selection tab, enable the Show all columns option. From the Events Selection tab, select the Stored Procedures RPC: Completed event and all columns.
Click the Column Filters button and select TextData. Expand the Like option and paste the session id within percent signs: %sessionid%
Confirm the end user is ready to reproduce the issue. Click the Run button. Reproduce the issue while the trace is running. After reproducing the issue, wait one minute to make sure all traffic was captured. Stop the trace. Save the trace to a trace file (.trc). In the results, check the Duration column for any rows running a long time. NOTE: the time is in milliseconds. The TextData value will contain the name of the SQL stored procedure. From SQL Management Studio, open a new query window. For each stored procedure taking a long time, clear the bad data query plan by running the following SQL command after replacing "stored procedure name".
sp_recompile 'stored procedure name'
|