Welcome to the Performance Virtual Chapter

Source: http://www.flickr.com/photos/adamkr/4595762893/ We focus on Performance Tuning with regards to SQL Server, attached storage area networks, database design, and IP network.

The Performance Virtual Chapter Mission Statement: Empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ET. Every month there is a drawing for a $50 Amazon gift card sponsored by Confio. To be eligible, you just need to attend our monthly webcast. A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address.

You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

		May 2012 Presentation
DMVs - Understanding an Application's Database Usage by Jerry Brenner Thursday, May 24 2012 at 2:00 PM EDT add to Calendar Abstract The DMVs contain a wealth of information about how your application uses the database. This talk will describe how to build a tool to mine the DMVs to get a good picture of how your application uses the database, leveraging your understanding of your application and/or it’s data model. By building a tool in a programming language, instead of relying on scripts, you can use set operations to minimize the number of queries executed against the database and then correlate information from a variety of DMVs and system tables. For example, you can execute a single query to get the execution statistics, text and showplan xml for the top N queries and then use XPath on the client to query the showplan xml and extract a wealth of information. Bio Jerry Brenner is Lead Performance Engineer at Guidewire, spending a lot of time developing tools that mine the DMVs and system tables, to enable quick debugging of performance issues. He spent the first half of his career working on query optimizers and implementing SQL functionality. He was technical lead for the rewriting of subquery processing in Sybase, so that Peoplesoft could release on Sybase and an original member of the query processing team at Cloudscape. Attend the Live Meeting Sponsored by Confio

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.

		Sponsors

Contact the Performance VC

Email:

Name:

Subject:

Message:

Send