PASSMN April 21, 2009 Monthly Meeting
Posted by denglishbi on March 19, 2009
The next PASSMN Minnesota SQL Server User Group meeting is coming up. The meeting is on April 21 from 4:30 PM to 6:45 PM. You can visit the local site to get registered at http://www.mnssug.org or click on the link to register here.
This month the topics are:
Drive Your Way to the DMV (speaker Jason Strate, Digineer) – Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have been around since the release of SQL Server 2005. But for many people DMVs and DMFs are still a mystery. Step under the hood and review some of the main DMVs and DMFs in SQL Server. From sessions to caches a walk through of some of the more useful DMVs and a practical look at what they all really mean.
Performance Troubleshooting with Wait Statistics (speaker Joe Beck, Microsoft) – When encountering a performance issue on a SQL Server instance, where do you begin? DBAs sometimes use troubleshooting methods that are biased towards past experience, instead of using a disciplined and consistent methodology. The danger of using instinct-based methods is that you may overlook the true root cause, or spend time troubleshooting less significant bottlenecks. In this session, Joe Sack will walk you through how to troubleshoot performance issues by evaluating Wait Statistics, which represent waits encountered for executed threads on a SQL Server instance. Joe will also discuss common wait type patterns seen in the field, and describe recommended next steps and resolutions. Performance troubleshooting with Wait Statistics allows you to focus on the higher priority bottlenecks, saving you time, and allowing you to apply your efforts towards the most impactful changes.
Just a reminder that the group meets on the 3rd Tuesday of each month. If you are in the area and available to attend please join us and stop by and say ‘Hi’.