SQL Server Performance Tuning

Bursa Malaysia Berhad is an exchange holding company. It operates a fully integrated exchange, offering the complete range of exchange-related services including trading, clearing, settlement and depository services.

Bursa Malaysia Berhad planed to engage us to purpose of application system optimization and improvements. The objectives of the engagement are to resolve the intermittent system performance issue and to improve system functionalities. The Fard Solutions therefore, expected to analyze, advice and resolve the issues accordingly and enhance the system with new functionalities.

The Fard Solutions is expected to have skill sets in the following areas (Which we covered beyond what it required):

  • Experience in MS-SQL 2005 database design, normalization, indexing, fine-tuning and optimization.
  • Experience in database integration service (SSIS) package development and fine-tuning.
  • Experience in design, development and coding web application on .NET and VB.NET programming language using MS Visual Studio 2008.
  • Experience with front-end technologies such as HTML/XHTML, Java-script, Web Service.
  • Experience in MS Reporting Service (MSRS) development.
  • Able to operate and conversant with MS Windows Server 2003 Operation System.

The Fard Solutions is expected to perform, but not limited to the following scope of work:

  • To optimize system performance and resolve the intermittent performance issue.
  • To refine the application code behind for the system to work more efficiently.
  • To refine simultaneous multiple processing, process queuing system.
  • To enhance stored programs queries to allow faster execution time.
  • To redevelop EODjob component.
  • To refine data transfer 5515 packages.
  • To advice on the hardware and infrastructure capacities.
  • To enhance the system.

Automated Risk Management and Decision Making Analaysis (ARMADA) System is the centralized system for BURSA MALAYSIA BERHAD to collect and process all the stock market data from broking houses and investment banks. Our consultants managed to finish this project within five (5) working weeks which was a kind of surprise for Bursa Malaysia team. The followings are the SQL Server consultancy outcome:-

  • The computation process time reduced from 22 minutes to 5 minutes.
  • SQL Server overall performance is improved 77.3%.
  • The database size reduced from 103GB to below 43GB.
  • Transaction Log file size reduced from 100GB to 7GB and file size is maintaned.
  • SQL Server I/O consumption reduced 49%.
  • SQL Server CPU usage from 55% dropped to 25%.
  • Database internal and external fragmentation is reduced by 70%.
  • The major queries time consumption reduced 45.5%.
  • Database management is simplified base on new database physical structure.
  • Administrator is able to restore database online while users are connecting to the system without any downtime, unless the MDF file is corrupted.
  • Administrator is able to recover and restore database up to the failure time or specific time.
  • SQL Server improves the Execution Plans for having better performance.
  • Database consistency improved by checking and signing data.
  • Database expansion operation improved 100% by reserving the physical space.

Share This Story

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

Share Your Comments

Leave a Reply

avatar
  Subscribe  
Notify of

About The Author

Search Articles

Categories

Follow Fard Solutions

Share Your Comments

Leave a Reply

avatar
  Subscribe  
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

info@fard-solutions.com

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