SQL Server Performance Tuning

The estimated reading time for this post is 1 minutes

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.

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

View Testimonial

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn


Tags: