Class Info

Online Course: Storage and Virtualization for the Database Administration

Get Full Access for Only $49.00  

Course Overview

SSWUG.ORG’s virtual class will provide database administrators (DBAs) with the skills to properly design storage and virtualization solutions.

Denny Cherry, course instructor and SQL Server MVP, will explain why storage can be one of the largest bottlenecks when it comes to database performance.

He will also explain why it can be one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not get along. Finally, he will dig into LUNs, HBAs, the fabric, as well as the storage itself.

In the second half of the course, Denny will review the pros and cons of moving SQL Servers into a virtual environment. He will also explain how to tie virtual platforms to the storage array, so that DBAs can maximize the storage performance for their SQL Servers and the virtual environment.

Sessions

Storage Array Basics (Part 1) –  Topics in this session include:

  • Storage Terminology
  • Cache
  • Basic Hardware Overview
  • Flash Cache
  • RAID Types

Storage Array Basics (Part 2) – Topics in this session include:

  • Monitoring
  • Power Up / Down
  • Spindle Types
  • Tiered Storage

Storage Array Basics (Part 3) – Topics in this session include:

  • Disk Alignment
  • Buss Speeds
  • Array Diagram

Storage for Performance – Topics in this session include:

  • Selecting the correct RAID type
  • When to change RAID types
  • How arrays can change RAID types

Advanced Array Concepts (Part 1) – Topics in this session include:

  • Array Design Techniques
  • Snapshots
  • Clones
  • Copy on First Write
  • VSS

Advanced Array Concepts (Part 2) – Topics in this session include:

  • Replication
  • MPIO
  • Thin LUNs
  • Automated Storage Tiring with EMC FAST and Dell Compellent

Storage Area Networks – Topics in this session include:

  • Network Options (iSCSI, Fiber Channel, FCoE)
  • iSCSI tuning techniques
  • Network Design
  • World Wide Names
  • Zoning
  • ISL
  • Monitoring

Virtualization Overview – Topics in this session include:

  • Platform Overview (VMware, Hyper-V, Zen, Virtual Box)
  • Why we virtualize
  • Pitfalls
  • Deciding Factors

SQL Server in a Virtual Machine – Topics in this session include:

  • Diagnosing CPU Problems
  • Balloon Drivers
  • Memory Deduplication
  • Storage Configuration
  • Monitoring
  • Licensing

High Availability (HA) Options – Topics in this session include:

  • Storage and HA
  • Special considerations for Database Mirroring / Always On
  • HA options for Virtual Platforms (vSphere, Hyper-V)
  • SQL Server and HA

Disaster Recovery (DR) Options – Topics in this session include:

  • Storage & DR
  • DR options for Virtual Platforms (vSphere, Hyper-V)
  • SQL Server & DR

 

 

Speaker


Denny CherryDenny Cherry
is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2008 including the Microsoft Certified Master as well as being a Microsoft MVP for several years. Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

Preview

 

Facebooktwittergoogle_plusredditpinterestlinkedinmail