Pinal Dave
MS Computer Science
SQL Server Performance Tuning Expert
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.
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.
We will have very different approaches to solving the performance problems of SQL Server - we will have stories related to real world scenarios and practical approach of solving performance problems.
We will primarily discuss:
- 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
You will learn:
- Performance Tuning
- Best Practices
- Index and Query Tuning