Getting the most from your SAN – File and Filegroup Layout – with Stephen Archbold

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 SQL Consultant at Prodata Business Systems, with over 6 years experience working with 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.

Microsoft Atrium, Sandyford. Limited parking available accessible from the rear of the building.


January 7th, 2014 18:30 – 20:30

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s