This Saturday I will be in Kalamazoo, which I thought was the birthplace of Derek Jeter but it turns out that he was born in New Jersey and moved to K-zoo when he was four. I am guessing that as part of the speaker dinner we will also get a tour of Jeter’s childhood home but I haven’t been able to confirm those details yet. Needless to say you can rest assured I will take pictures of the house should I get a chance.
I have two sessions lined up for Saturday. Here is what they are about:
Monitoring Databases in a Virtual Environment
Abstract: When moving databases to a virtual environment the performance metrics DBAs typically use to troubleshoot performance issues such as O/S metrics, storage configurations, CPU allocation and more become unreliable. DBAs no longer have a clear, reliable view of the factors impacting database performance. Understanding the difference between the physical and virtual server environment adds a new dimension to the DBA tasks. This presentation describes the changes that DBAs need to make in their performance and monitoring practices.
What this means: It means that when you go virtual you have an extra layer of abstraction to investigate as a possible root cause. Failure to do so will cause you to waste time when trying to resolve performance bottlenecks. I will walk you through some performance scenarios as well and help guide you to making better decisions about architecture, design, and resolving issues.
Who should attend: Anyone running SQL Server on VMWare and is still using Task Manager to determine if there is a problem. On second thought, I don’t want you coming, you are probably going to be more trouble than you’re worth. I want people coming that have heard of vSphere, or vCenter, but don’t know the difference, or why they should care about them. I also want people who have extra slices of bacon, since this talk is close to breakfast time.
Waits and Queues and You
Abstract: Many database professional have little to no understanding about how to use wait events as part of an overall performance tuning process. And yet wait events are the secret sauce that many leading experts have been using for years. Attend this talk and you will gain an understanding of the SQLOS execution model, an understanding of how to use DMVs to find out what your queries are waiting for, and why using wait events could be the best thing to happen for your career as a DBA.
What this means: I am going to explain to you how the database engine processes statements in terms of the “running-waiting-runnable” cycle. And I am going to do so by drawing comparisons between the SQLOS and to the most efficient, professional, consistent organization on Earth: the TSA.
Who should attend: Anyone that has never heard of the SQLOS, or has gone through a TSA checkpoint. But only if they don’t ask any questions because the talk is late in the day and I will likely need a nap.
There you go, see you Saturday, I can’t wait to hear what I will say!
Can’t wait to see you Tom! I’ve purchased lye and have that hole dug in the backyard so we can bury any evidence of wrongdoing at the Speaker and Volunteer Dinner on Friday.
There are 100,000 people in the Kalamazoo Metropolitan Area. I couldn’t tell you where Derek’s childhood home is if I tried.
Interesting Fact: Colon lies to our Southeast. Climax is between here and Colon.