|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.
5:45 – 6:15: Registration & Intro
6:15 – 7:15: Get the most from your storage
7:15 – 7:30: Refreshments and Networking
7:30 – 8:30: SQL Server Integration Services 2012, Deployment Model and SSIS Catalog
Registration can be found www.eventbrite.co.uk/event/7622917351, if you have any queries please email firstname.lastname@example.org
Get the most out of your storage
Stephen Archbold, SQL Consultant Prodata
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
SQL Server Integration Services 2012
Fintan Guihen, SQL Consultant Prodata Business Systems
With the release of SQL Server Integration Services 2012, there is a new “Project Deployment Model” available to us. In this session we will take a look at this new model, and how it helps improve an SSIS Developers life with its new package deployment, configuration and logging features. We’ll also take a look the new SSIS Catalog, and how it compares to the Package Deployment of SSIS 2005/2008.