VMware: Becoming a Query Performance Troubleshooting Expert
Every DBA wants to become an expert in query performance troubleshooting.
Not every DBA is willing to put in the time and effort it takes to become an expert.
The #hardtruth here is that to become an expert in anything you need a combination of two factors: experience and knowledge. You don’t become an expert overnight, or by going to any one conference, or by attending any particular class.
Today I’m here to share some knowledge to help get you started on the path to expert query performance troubleshooting. The first step is to watch this video from the PASS Summit in 2010. Yes, that’s right, it’s from seven years ago. The video is 77 minutes long, make certain to set aside enough time:
One of the main takeaways from this video I want you to have is the fact that troubleshooting performance is not always rocket surgery. I’m a huge fan of using “buckets” to help troubleshoot issues. It’s one of the reasons I fell in love with wait events about 2006.
Read the entire article here, Becoming a Query Performance Troubleshooting Expert
Via the fine folks at VMware!