4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

SSIS Performance testing and optimisation using Hashing

There are several patterns in SSIS that are easy and super useful - once
you know them! In this session, you will learn how to create a performance
testing framework to run multiple versions of your package, how to run packages
in parallel, and a hashing algorithm based on FNV1a to vastly improve your load


In this session, you will learn a very basic pattern
for performance testing different techniques, and Mark will demonstrate the
performance impact of some such basics of sorted and unsorted recordsets, fast
parse and others using this pattern, and pull the results into PowerPivot.

Then, an alternate mechanism for creating IDs other
than using an identity will shown, based on using the FNV1a hashing mechanism
in a script component, and the various methods of handling collisions will be


Basic SSIS and T-SQL skills are required to follow the
session. Having used a script component previously will be advantageous, but
not required.
Presented by Mark Stacey at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business / technical boundaries in Business Intelligence, working in both SharePoint and SQL.

    He has published 2 books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQL Saturday and SharePoint Saturday events.

    He is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies


  • Video
    The video is not available to view online.