Tuesday, July 18, 2023

Performance Questionaire

 


Are they Hosted? If yes where -?

 

JDE Detail –

 Application Release –

Tool Release –

Bitness -

Batch Server – OS/RAM/CPU

Database Server and Version –

Database Server  - OS/RAM/CPU

 

 

JDE –

 

Since when the issue is happening ?

Any recent changes done at hardware level or JDE Software (New Promotion) or Third Party ?

Last Full Package build date ?

Run Report R9698711 and see missing index as per JDE Standard?

Does Job remain in Wait Status long enough before start Processing?

Is this Standard or Using custom?  Custom BSFN, RDA or Table etc ?

Can Job be run with AntiVirus turn off on Enterpriser and Database Server and See performance?

 

Does Payroll Job Run Faster if it run’s in single threaded Queue ?

Is there specific time when Job run faster and time when Job run slower ?

What parameter is the comparison of Job performance?

Does Same Job run faster in one environment vs other environment?

Does any other Job is slower

 

DBA -

Verify Database is performance ?

Check Index on Database?

Check Fragmentation on Database?

Check Database Backup timing and see if timing is conflict when the job is running?

 

Infra Team

Check Performance of System for last 10 days.  Provide Screen Shot for monitoring ?

Which Antivirus running and is JDE Folder excluded ?


Friday, July 7, 2023

JDE Tables

 CNC Tables

F986101 - Object Configuration Master

F98611 - Data Source Master

F98230 - OMW System Settings

F95921 - Role Relationships Table

F9654 - Deployment Locations Definition

F9651 - Machine Detail

F9650 - Machine Master

F00950 - Security Workbench Table

F00945 - Release Master

F00942T

F00941 - Environment Detail - One World

F00942 - Object Path Master File

F0094 - Library List Master File

F0092 -  Library Lists - User


ESU Table

F9670 - Software Update Master Table

F9671  - Software Update Detail Table

F9672 - Software Update Pathcode Information

F98881 - Specification Merge Logging File

F988810 - SpecMerge Tracking


Package Tables

F98220

F98221

F98222

F98223

F98224


Package Table

F9603

F96511

F98825

F98226