-
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
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.
- relates to
-
-
- New Request
-
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Summary | Need to check for OES_SP_ResetExpireSessionsLogins performance | Query Performance - OES_SP_ResetExpireSessionsLogins |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: LB QA(10201) |
| Assignee | Saurabh Sablaka [ saurabh.sablaka ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Item State | Parent values: LB QA(10201) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Code Reviewed By | Vijayendra Shinde [ 11901 ] |
| QA | Rashmita Dudhe [ rashmita.dudhe ] |
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Comment |
[ Verified on Mobile device for Partner, Admin, Employee Working fine as expected ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Saurabh Sablaka [ saurabh.sablaka ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Assignee | Saurabh Sablaka [ saurabh.sablaka ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Attachment | Sceanrio_New.xls [ 20742 ] |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Production Complete(10222) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |