Project

General

Profile

Bug #3932

Request Buat Job Untuk Handle Memory Ketika Running Payroll Prod BIA

Added by Mr Ikmal 3 days ago. Updated 3 days ago.

Status:
Deploy
Priority:
Urgent
Assignee:
Mr Ikmal
Start date:
10/03/2025
Due date:
10/03/2025 (3 days late)
% Done:

0%

Estimated time:

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

#1

Updated by Mr Ikmal 3 days ago

  • Due date set to 10/03/2025
#2

Updated by Kezia Pawitra Yulianti 3 days ago

  • Status changed from New to Assigned
  • Priority changed from Normal to Urgent
#3

Updated by Muhammad Bintar 3 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

#4

Updated by Mr Ikmal 3 days ago

  • Status changed from QA Test to Deploy

oke terima kasib mas bin

Also available in: Atom PDF