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