SAN eye for the SQL girl/guy

Most Enterprise-scale deployments feature SAN-based storage. As the SQL DBA we rarely get our hands on these cool toys BUT more and more senior roles require at least some familiarity with SAN technologies - so how do you get this required experience? Answer: come to this session, of course (!) -a '90% practical' session - featuring the return of Hue's popular 'no bullets' slides - and gain this exposure.

Hue will bring 2× different training 'SAN in a box'es - one based-on Microsoft and one with an interface more akin to what you'd find in a typical datacentre. SAN storage will be provisioned in-front of your eyes and you'll see technologies like iSCSI in action and explore uniform and mixed storage pools and LUNs aplenty!

The second part of the session will focus entirely on troubleshooting SAN issues - where we'll explore some of the SAN 'dark speak' such as IOPS, queue lengths, I/O size and use Microsoft's SQLIO to test the SAN before we even deploy a DB - OR troubleshoot performance problems.

A '400 Advanced' session in parts BUT frequently returning to basic concepts before 'deep diving' again - come along, I'll guarantee you'll pick-up some new tricks and much needed Enterprise technology exposure.
Presented by Hue Holleran at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 3.1 MB
    Video available MP4 Video HD 446 MB
  • SpeakerBIO
    Hue_Holleran.jpg
    Hue Holleran is a professional consultant specialising in Enterprise RDBMS solutions: SQL Server since v4.2, Oracle since v7 and Hadoop since its first releases - and all versions of those products since. After more than 20-years as a consultant to over 100-organisations - and the largest global brands in various industries - Hue has established a reputation for developing innovative BUT practical solutions. Since developing in mainframe 'C' and DBase/FoxBase+ in the 1980's and Oracle and SQL Server in the 1990's, Hue's current interest is in multi-terabyte and multi-threaded BigData and Enterprise-scale solutions. Hue has frequently presented on various topics since presenting for Microsoft at all UK venues for the Visual Studio 6 launch in 1998, Hue's current focus is on leveraging the database's enterprise capabilities to implement truly robust and resilient systems that retain excellent performance even in the most challenging of environments.
    http://www.hueholleran.com/
  • Video