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: 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