We came across this SP "OES_SP_ResetExpireSessionsLogins" while checking for ASP State session issues. This SP is called inside "DeleteExpiredSessions" SP of ASPState db that clears out the expired sessions at interval of 1 minute.

The logic inside this SP checks for active user flags across all production companies which might take considerable time in execution. We need to visit this StoredProc and analyse the activity & time taken every time it executes.