SQL Server: Performance Tuning Best Practices

SQL Server: Performance Tuning Best Practices


Invite friends

Contact Us

Page Views : 177

About The Event

In this session we will try to bridge the gap between DBA and Developer. We will approach performance as a whole subject rather than dividing them into DBA or Developer problems. Performance Tuning is a tricky subject, but not as difficult as we think. It is very common to see in this industry that the DBA believes the performance issue is due to bad code and the Developer believes it is due to the bad deployment of the database server.

Primarily Discussion

  • Best Deployment Practices
  • Indexes, Best Practices and Maintenance
  • Identifying slow running queries and Tuning
  • Identifying resource bottleneck with the help of SQL Wait Stats
  • Optimizing Resources - CPU, IO, Memory
  • Best Practices to Resolve ad-hoc issues