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.  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 the June Gift Card Winner...Will Lansing!

 

GoToWebinar requires registration through the RSVP link below.
Next Meeting

Thu, Aug 22 2013 14:00 Eastern Daylight Time


Monthly Meeting - August 2013

RSVP: https://attendee.gotowebinar.com/register/8752802303369138944

Recording: https://attendee.gotowebinar.com/register/8752802303369138944

Getting the most from your SAN - File and Filegroup Design Patterns

https://attendee.gotowebinar.com/register/8752802303369138944
Abstract : You’ve been given the task of optimising the File and Filegroup layout to get the most from your storage. Not sure where to start, or thinking you could get a more from your storage with a different design? Are your SAN guys telling you your storage can process 2 GB/s but you're only seeing 200 MB/s? This session will dive into how to optimise your file and filegroup layout strategy to get the most from your I/O Subsytem, including a case study where we took a customers table scans from 500 MB/s to 1.2 GB/s with only a change in filegroup layout. Topics covered include:
- Layout for OLTP
- Data Warehousing Fast Track Style
- Data Warehousing on a SAN
- Get data into your SSAS cubes faster (ProcessData)
- Hidden options and “go faster” buttons
- How to maximise performance in enterprise edition and master read ahead


Stephen is a Microsoft Certified Master, and a SQL Server Consultant at Prodata Business Systems, with over 6 years experience working in SQL Server as a Production DBA. He has a focus on Performance Tuning and Consolidation to get the most from your investment in SQL Server.