Geeks With Blogs

News Brandy Favilla is currently the Community Engagement Manager at New Horizons of Minnesota ( In this position, she helps people define and build their careers through educational events. Brandy focuses on networking with members of the Information Technology community to form partnerships in education. She strives to maintain New Horizons’ reputation as a high-quality learning center throughout the Twin Cities and beyond. Some of her accomplishments include chairing the committee for both the TechFuse and MindSurf Conferences hosted by New Horizons, co-chairing Twin Cities Code Camp and Twin Cities SharePoint Camp, Co-host of the Twin Cities Developers Guild, VP of PR for TechMasters (, Communications Chair of PACT (, Programs chair for IAMCP, President of the Business Intelligence User Group ( and actively participating in the SharePoint User Group ( *the thoughts and opinions in this blog are my own and do not reflect the opinions of New Horizons of Minnesota
Twin Cities IT and Developer Events Postings by Brandy Favilla
April 21, 2009
3:00 PM - 5:15 PM

Minnesota SQL Server User Group

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.

Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to Microsoft’s published white paper "Empowering Enterprise Solutions with SQL Server 2005 Enterprise Edition" and actively blogs about SQL Server and related technologies. Also this year, Jason participated in the development of Microsoft Certification exams for SQL Server 2008, presented at the SSWUG SQL Server Launch Event and is presenting in upcoming SSWUG SQL Server Conference.

Performance Troubleshooting with Wait Statistics
Joe Sack, 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.

Joe Sack is a dedicated support engineer with Microsoft Premier Field Engineering based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, retail and the real estate industry. He blogs about various SQL Server topics on and is the author of the Apress books SQL Server 2000 Fast Answers for DBAs and Developers, SQL Server 2005 T-SQL Recipes, and most recently SQL Server 2008 Transact-SQL Recipes.

Register here! Posted on Thursday, March 26, 2009 9:41 AM | Back to top

Comments on this post: Drive Your Way to the DMV & Performance Troubleshooting with Wait Statistics

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © TwinCitiesITandDevEvents | Powered by: