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

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: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/528/completed-advanced-sql-server-database-administration-performance-tuning-bangalore-october-2011

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:

More pics can be seen from my FaceBook page at: http://www.facebook.com/#!/media/albums/?id=165298110161387

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

Have a SQL Server question? Join the fastest growing SQL Server facebook group at: http://www.facebook.com/groups/458103987564477/

Regards
Amit Bansal – www.FaceBook.com/AmitRSBansal
www.twitter.com/A_Bansal
www.twitter.com/SQLServerGeeks
www.amitbansal.net

Contribute on SQLServerGeeks.com: visit http://www.sqlservergeeks.com/default-category/write-for-us