The Performance Virtual Chapter's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Welcome to the Performance Virtual Chapter

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 $100 Amazon gift card sponsored by Confio a part of SolarWinds.  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.

Congratulations to this months gift card winner: Desirae Smith.

Next Meeting

Thu, Aug 25 2016 14:00 Eastern Daylight Time

August Meeting


Recording: None

SQL Server Storage

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. But Brandon Leach makes it fun by explaining the concepts and telling humorous stories along the way. In this session, Brandon will focus on how objects are stored in a data file.

You'll hear how these concepts tie in to your work as a DBA or developer. You’ll get to see the concepts in through demos and learn how you can use this knowledge to design better solutions. Brandon will also demo some neat tools to help you dig in and learn further.

After this session you will understand:
• The three basic types of storage in SQL Server
• The physical structure of a row and how it affects performance
• Differences in how SQL Server works with heaps and clustered indexes
• How pages are allocated and tracked
• How to use various tools to continue your learning

Brandon is a senior DBA and veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he quickly fell in love with SQL Server database development and administration. Currently he is a senior DBA for SurveyMonkey. He works closely with the development, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met.