Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Storage 101 for the DBAs

PASS Data Community Summit via YouTube

Overview

Explore the fundamentals of SQL Server's interaction with storage systems in this comprehensive conference talk. Delve into essential concepts including disks, volumes, file systems, and performance monitoring counters. Gain insights into storage devices and crucial aspects for understanding database storage. Learn valuable best practices and troubleshooting techniques for swift issue diagnosis. Cover topics such as latency, IO block size, IOPS, throughput, SQL Server IO basics, checkpoints, bulk operations, asynchronous IO, file systems, hypervisors, storage protocols, and various storage technologies including Fibre Channel, NVME, and Persistent Memory. Understand the differences between block and logical replication to enhance your database administration skills.

Syllabus

Intro
Sponsors
Introduction
Agenda
Latency
IO Block Size
IOPS
throughput
SQL Server IO Basics
Checkpoint
Bulk Operations
Asynchronous IO
IO Block Sizes
NFS vs RDFS
SMB
Linux
SQL Server
Hypervisor
Storage Protocol
Fibre Channel
NVME
NVME Over Fabric
Persistent Memory
Block vs Logical Replication

Taught by

PASS Data Community Summit

Reviews

Start your review of Storage 101 for the DBAs

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.