Bug #3932
Request Buat Job Untuk Handle Memory Ketika Running Payroll Prod BIA
Added by Mr Ikmal 3 days ago.
Updated 3 days ago.
Due date:
10/03/2025 (3 days late)
Description
Dear mas Bin,
Mohon bantuannya untuk membuat job di SQL yang dapat menangani server di 89, karena akhir2 ini sering terjadi error dan proses running menjadi lebih lama dibanding sebelumnya ada kemungkinan karena memory sedang tinggi mas.
Terima kasih.
PORT PROD : https://hris-bia.minovaiscloud.com/
DB : 103.153.60.89,1435
Nama DB : MinovaES_BIA_Prod
PORT DEV : http://remote.minovais.com:61139/
DB : remote.minovais.com, 1468
Nama DB : MinovaES_BIA_BaseServerCloud
- Due date set to 10/03/2025
- Status changed from New to Assigned
- Priority changed from Normal to Urgent
- Status changed from Assigned to QA Test
- Assignee changed from Muhammad Bintar to Mr Ikmal
ini ya query nya
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
/*** Drop the max down to 64GB temporarily /
sp_configure 'max server memory', 3048; --3GB
GO
RECONFIGURE;
GO
/* Wait a couple minutes to let SQLServer to naturally release the RAM..... */
WAITFOR DELAY '00:03:00';
GO
/ now bump it back up to "lots of RAM"! ***/
sp_configure 'max server memory', 16000; --16 GB
GO
RECONFIGURE;
GO
- Status changed from QA Test to Deploy
Also available in: Atom
PDF