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

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

Monthly Meeting - August 2013

Thu, Aug 22 2013 18:00 UTC

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

<a href="https://attendee.gotowebinar.com/register/8752802303369138944"><b>https://attendee.gotowebinar.com/register/8752802303369138944</b></a> <br> <b>Abstract : </b>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: <br>- Layout for OLTP <br>- Data Warehousing Fast Track Style <br>- Data Warehousing on a SAN <br>- Get data into your SSAS cubes faster (ProcessData) <br>- Hidden options and “go faster” buttons <br>- How to maximise performance in enterprise edition and master read ahead


Stephen Archbold

Stephen is a Microsoft Certified Master, and a Lead DBA at Arrowstreet Capital, with over 8 years experience working in SQL Server as a Production DBA and consultant. He has a focus on Performance Tuning and Consolidation to get the most from your investment in SQL Server.

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids