Support #12907
[SCP ID :##6236##] : DB CPU High
Status: | Work Completed-End life cycle | Start date: | April 07, 2022 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | Technical | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
DB (SACDA935) CPU high due to select statement for Auto Credit. Request to add index in db table
Related issues
History
#1 Updated by Nurul Athira Abdul Rahim over 2 years ago
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
#2 Updated by Najmi Pasarudin over 2 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
#3 Updated by Najmi Pasarudin over 2 years ago
- % Done changed from 0 to 90
#4 Updated by Najmi Pasarudin over 2 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Najmi Pasarudin to Nurul Athira Abdul Rahim
Issue:
Database CPU usage is 100% for a long time. Can reach an hour causing BSNeBiz failed to load login page.
Finding:
File processing table, column Batch ID is not indexed.
Solution:
Add index to File processing table, column Batch ID. This will improve search/enquiry speed.
- Comfort test Bulk Payment, Auto Debit and Statutory modules
- Run EOD.
- Expected result, file processing work as usual
#5 Updated by Nurul Athira Abdul Rahim over 2 years ago
- File 12907 - SCP ID - 623 - DB CPU High.docx added
- Category set to Technical
- Status changed from Internal Testing to System Integration Test
#6 Updated by Nurul Athira Abdul Rahim over 2 years ago
- Status changed from System Integration Test to Pending Prod Deployment
- Assignee changed from Nurul Athira Abdul Rahim to Najmi Pasarudin
Tested and passed by Asrul on 250422
#7 Updated by Nurul Syahirah Md Nawi over 2 years ago
- Status changed from Pending Prod Deployment to Pending Review
- Assignee changed from Najmi Pasarudin to Nurul Syahirah Md Nawi
Production deployed on 19/5/22
#8 Updated by Binti Marobi Athirah Umairah about 2 years ago
- Status changed from Pending Review to Work Completed-End life cycle
- Assignee changed from Nurul Syahirah Md Nawi to Zahir Abd Latif
- % Done changed from 90 to 100