SQL Server Performance Tuning

ghlGHL Systems’ the ASEAN premier payment services provider has complete portfolio of payment solutions include transaction routers and concentrators, terminal line encryption technologies, loyalty and online payment solutions, smartcard technologies, secure EDC networks and terminals, as well as consulting and professional services. It offers its services within Malaysia and to overseas markets.
NetAdmin System is the centralized system for GHL SYSTEMS BERHAD to collect and process all the CreditCards and DebitCards data from POS devices,then sending results to the assigned bank for further processing.

Key Points:

  • The data retrieval time consumption reduced from 3 minutes to less than 5 seconds..
  • SQL Server overall performance is improved 97.2%.
  • Number of transactions increased from 500,000 to 1,500,000 per day.
  • Transaction Log file size reduced from 250GB to 20GB and file size is maintaned.
  • SQL Server I/O consumption reduced minimum 70%.
  • SQL Server CPU usage from 76% dropped to below 35%.
  • Database internal and external fragmentation is reduced by 60%.
  • The major queries time consumption reduced 60.5%.
  • Database management is simplified base on new database physical structure.
  • SQL Server improves the Execution Plans for having better performance.
  • Database expansion operation improved 100% by reserving the physical space.


Our SQL Server Principal Consultant is the Only Microsoft Certified Master in South-East Asia.

View Testimonial

Share This Story

Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp

Share Your Comments

Leave a Reply

Notify of

About The Author

Search Articles


Follow Fard Solutions

Share Your Comments

Leave a Reply

Notify of

Fard Solutions Sdn. Bhd. Company was established in 2012 in Kuala Lumpur. We are engaged in development, implementation, integration and maintenance of the most advanced database solutions and IT research & development (innovation).

(+60) 03 8994 6788


Fard Technology Corp.
700-1199 West Hastings Street,
Vancouver, British Colombia,
V6E 3T5 Canada.

Fard Solutions Sdn. Bhd.
1-1C & 1-2C Incubator 1,
Technology Park Malaysia,
Bukit Jalil, 57000
Kuala Lumpur, Malaysia.

  • Copyrights © 2020 Fard Solutions Sdn. Bhd. , All rights reserved.
  • Privacy Policy
  • Terms of Service
  • A Project By Website Artisan