SQL Server 2012 -Performance Tuning and Optimization Training


Course Duration: 3 Day(s)


Participants will learn various ways of tuning servers and how to write an effective query using T-SQL langusge which is used to interact with SQL Server Database.


  • Components of the SQL Server Architecture
  • Physical Database Architecture
  • Creating and Managing Databases
  • Managing Transactions, Locking, and Blocking
  • Monitoring SQL Server Performance
  • Performance Tuning of T-SQL
  • Statistics Analysis
  • Fragmentation Analysis
  • Monitoring and Configuring SQL Server
  • Managing Workload with Resource Governor
  • SQL Audit
  • Automating SQL Server
  • Using SQL Server Profiler

Who Should Attend

Participants attending this course must have development experience on:

  • RDBMS Concepts and be proficient in writing SQL Scripts

Target Audience



Chitra Iyer

Chitra has been delivering exceptionally well in her professional capacity as consultant and trainer.  She has been successful at adopting new technologies for tackling IT challenges which makes her forefront in driving new technology adoption cycle amongst the growing developer base in India.

An excellent communicator, Chitra perfectly fits the bill in handling clients whilst offering technological solutions them by understanding the key requirements of the client expectations.  

Mr. Kedar Ghanekar

Definitely an asset to Synergetics, Kedar has played an in dominatable role in delivering training engagements as well as enterprise solutions. Over the years, Kedar has garnered immense training skills which are put to use along with his knowledge on beta technologies. He has been able to comply to the toughest of software challenges by applying beta technologies in real time scenarios.