Bug #3932
Request Buat Job Untuk Handle Memory Ketika Running Payroll Prod BIA
0%
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
Updated by Kezia Pawitra Yulianti 23 days ago
- Status changed from New to Assigned
- Priority changed from Normal to Urgent
Updated by Muhammad Bintar 23 days ago
- 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