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:

1_Completed_Advanced_SQL_Server_Database_Administration_Performance_Tuning

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

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 www.PeoplewareIndia.com