Completed-Advanced SQL Server Database Administration & Performance Tuning – Hyderabad, December 2011

Hi Friends,

Today, while I write this blog, we are already in June 2012. And I am going to talk about my assignment that I completed in December 2011. Yes, there is lot of back log 🙂

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

In fact this was my last assignment in year 2011.

Prior to this assignment, I completed an advanced SQL administration and performance tuning in Bangalore in October 2011 – you can find that blog here;

So what happened in the whole of November? No assignments? Well I took a break from work as I was blessed with a baby boy 🙂
I was not supposed to work even in December but you know, how much I love my assignments 🙂

So, this assignment was for a product development company based out of Hyderabad. They used SQL heavily as a back end for their product. Large database sizes degraded performance and this is where I was required to pitch in to explain advanced troubleshooting scenarios and techniques to find the root cause of a problem.

This was yet another opportunity to talk about the importance of having baseline numbers – which many clients do not have until they hit performance issues. I then focused on wait stats as the beginning point and performance monitor counters. It was good to discuss the 300 ms value of PLE 🙂


I stressed a little more on IO as IO is a very critical resource for any databases. I demoed a couple of DMVs, perf counters, and talked about some best practices in SQL Server deployment. Also advised the folks to go for RAID 10 if the client had the money 😉

This was a 5 day workshop and I thoroughly enjoyed working with them. The audience was so focused, and I was glad to make new friends !

I loved interacting with the folks; they made an excellent class.

Here are is the Pic from the class:


The gallery page on Peopleware India site is updated as well:

My next batch was in January in Kerela 🙂 – will write about it shortly.

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




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: He is on Twitter:

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.