Project SimpleProject Type: software

Project Simple

Uploaded image for project: 'Project Simple'
  1. Project Simple
  2. ST-174

Query Performance - OES_SP_ResetExpireSessionsLogins

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Production Complete
    • Issue Importance:
      Must Have

      Description

      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.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. ST-175 Query Optimization for performance

          • High - Serious problem that could block progress.
          • New Request

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

            Changes done: We have removed call of this Stored Proc from ASP State - Delete session. This code block was required to avoid Multiple Login error message when user has logged out and still session remain active in any scenario. Now that we do not have blocking for Multiple login as per client's request this call can be removed.

            Please verify basic scenarios for Login / Logout, Multiple Login & SSO (if possible) for all user roles.
            Login & Logout scenarios for all user roles [SA, Admin, Partner/Broker, Employees]
            System access from Mobile Device, Web browser
            SSO login
            Multiple login from same domain
            Multiple login from different domain
            Multiple login from Mobile Device & Web application

            Show
            saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - Changes done: We have removed call of this Stored Proc from ASP State - Delete session. This code block was required to avoid Multiple Login error message when user has logged out and still session remain active in any scenario. Now that we do not have blocking for Multiple login as per client's request this call can be removed. Please verify basic scenarios for Login / Logout, Multiple Login & SSO (if possible) for all user roles. Login & Logout scenarios for all user roles [SA, Admin, Partner/Broker, Employees] System access from Mobile Device, Web browser SSO login Multiple login from same domain Multiple login from different domain Multiple login from Mobile Device & Web application
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified On LB Environment for
            Login / Logout, Multiple Login
            For Admin, Partner, SA, Employee.
            Multiple login from same browser
            Multiple login from different browser.
            Multiple login from Mobile Device & Web application

            Not showing Multiple login Error message for multiple login.
            Working Fine as expected.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified On LB Environment for Login / Logout, Multiple Login For Admin, Partner, SA, Employee. Multiple login from same browser Multiple login from different browser. Multiple login from Mobile Device & Web application Not showing Multiple login Error message for multiple login. Working Fine as expected.
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified On Stage Environment for
            Login / Logout, Multiple Login
            For Admin, Partner, SA, Employee.
            Multiple login from same browser
            Multiple login from different browser.

            Not showing Multiple login Error message for multiple login.
            Working Fine as expected.
            Not able to test on mobile device stage login failed.

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified On Stage Environment for Login / Logout, Multiple Login For Admin, Partner, SA, Employee. Multiple login from same browser Multiple login from different browser. Not showing Multiple login Error message for multiple login. Working Fine as expected. Not able to test on mobile device stage login failed.
            Hide
            Permalink
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited

            Verified On Production Environment for
            Login / Logout, Multiple Login
            For Admin, Partner, Employee.
            Multiple login from same browser
            Multiple login from different browser.

            Not showing Multiple login Error message for multiple login.
            Working Fine as expected.
            Testing in progress for mobile device

            Show
            rashmita.dudhe Rashmita Dudhe (Inactive) added a comment - - edited Verified On Production Environment for Login / Logout, Multiple Login For Admin, Partner, Employee. Multiple login from same browser Multiple login from different browser. Not showing Multiple login Error message for multiple login. Working Fine as expected. Testing in progress for mobile device
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Rashmita Dudhe Status and item state is not matching, please update the current status.

            Hrishikesh Deshpande

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Rashmita Dudhe Status and item state is not matching, please update the current status. Hrishikesh Deshpande

              People

              Assignee:
              rashmita.dudhe Rashmita Dudhe (Inactive)
              Reporter:
              saurabh.sablaka Saurabh Sablaka (Inactive)
              Developer:
              Saurabh Sablaka (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: