Picture1SQL Server Optimizer is a software to check the specific SQL Server performance measures and on top of the findings it is able to generate TSQL codes for DBAs to review and execute the codes for having better performance.

  • Capture the SQL Server Critical Performance Statistic Data.
  • Generates TSQL Codes to Optimize the SQL Server Instance.
  • Supports SQL Server 2005, 2008, 2008R2, 2012, 2014.


  • 13 September 2015 – Version 1.0
    • Able to configure SQL Server for better performance.
    • Able to federate database objects base on the I/O usage.
    • Able to find and eliminate un-used indexes.
    • Able to find and defrag most fragmented indexes.
    • Able to find and create the most useful missing indexes.
    • Able to redesign the database objects to boost up performance. (Beta)
    • Able to redesign the TSQL queries to boost up performance. (Beta)

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