SQL Server Optimizer

The estimated reading time for this post is 0 minutes

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)

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: