[ST-178] Query Performance - OES_SP_Get_EnrollmentModesForEmployee - Workterra Jira

Details

Type: Enhancement
Status: New Request
Priority: High
Resolution: Unresolved
Component/s: Performance
Labels:
None

Module:
Platform - Performance
Reported by:
Support
Item State:
Development - Development Backlog
Issue Importance:
Must Have

Description

Call Stack:
WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
WORKTERRA.Employee_Enrollment.GetData(:0)
WORKTERRA.Employee_Enrollment.GetData(:0)
WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

StoredProc: OES_SP_Get_EnrollmentModesForEmployee

See this link for getting application code areas for select benefit type portion of the enrollment workflow (this is not exactly the same flow as the stack trace above though)

https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&tab-detail_ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50=trace_details&app_trace_id=ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50

https://rpm.newrelic.com/accounts/1155082/applications/13257194_h13531008/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&app_trace_id=ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50&tab-detail_ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50=trace_details

https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e47657444617461222c22225d&app_trace_id=116b603-e90e7676-4122-11e6-9cf7-f8bc12425d50