SQL Server: Completed- SQL Performance Tuning workshop in Chennai August 2011

Hi Friends,

After my performance tuning workshop for a leading bank in Gurgaon in July, it was time to train their other DBA team in Chennai.

This SQL Server training assignment in India was organized by Peopleware India

I had earlier blogged about my Gurgaon training here;

I don’t travel to Chennai too often so it was a welcome trip for me. Just like Gurgaon, it was a 4 day workshop for another DBA team of the same Bank & Financial Services company. I must say, the team was well experienced in troubleshooting bottlenecks. We drilled down on many performance counters and their recommended values. We also discussed a few exceptions. We had an interesting conversation on memory consumption and AWE in SQL Server. We spent a good deal of time on query tuning – and the most interesting aspect was index tuning when our search predicates used AND and OR operators. It was interesting to observe the behavior of optimizer. So, let me ask a question, if you have 2 indexes that are exactly the same (identical in terms of key columns and included columns), which index will the optimizer use if it has to use either one of them?

You can post your answer as comments below.

The folks in the classroom participated very well. I enjoyed delivering the workshop thoroughly. Thanks to all the folks. All in all, it was fun.

Here are 2 pics from the class:




The gallery page on Peopleware India site is updated as well: http://www.peoplewareindia.com/gallery.htm

I have already completed 5 more assignments after this but did not get time to write about them but shall do that shortly.

Thanks for reading ! Stay tuned for more details !

If you are looking for SQL Server training / consulting for your company / people, you can write to enquiry<at>peoplewareindia<dot>com or visit www.PeoplewareIndia.com




About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.