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.

		January 2012 Presentation
Discovering the Plan Cache Add to Calendar by Jason Strate January 26, 2012 at 4:00 PM EST Abstract Execution plans are stored after execution in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache you can find potential performance issues and opportunities to tune your queries. This information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session we will explore the plan cache and start you on the road to discovery. Bio Jason Strate, Digineer Inc, is a DBA with over fifteen years of experience. He is a recipient of the Microsoft Most Valuable Professional (MVP) for SQL Server since July, 2009. His experience includes design and implementation of both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Certification exams for SQL Server 2008. View Presentation Sponsored by Confio

		Upcoming Presentation
February – Jes Borland will present on Filegroups: Putting The Pieces Together

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