Production Ticket(ST) #9740
INC4696948 Commented: RGRP-msfsax01-360-retail-eye-prd Slowness
Start date:
14/08/2023
Due date:
21/08/2023
% Done:
0%
Estimated time:
Job Remark:
Ticket Logged Date:
14/08/2023
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
14/08/2023
SLA Delivery:
21/08/2023
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
14/08/2023
Resolution:
-
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:
None
Description
Dear Cris,
The request to increase DTU has been rejected, see the comment from the team below.
I’m not sure what’s the query ID refers to below, if your team do, I suggest to compile before and after the query optimization result.
Hi Cris,
Please check if can further optimize the script. The spike happens everyday on a specific time.
History
#1 Updated by Goy Chong Yu about 1 year ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Goy Chong Yu about 1 year ago
Findings:
high CPU usage from store procedure webSpReport_CnIssuance
#3 Updated by Goy Chong Yu 12 months ago
- Status changed from Support In Progress to Ticket Resolved
- Actual Initial Response set to 14/08/2023
- Resolution updated (diff)