Arizona SQL Server Users Group

Next Meeting: Wed, Apr 09 2014

AZ SQL Server User Group April Mtg: Intro to Storage Performance

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

AZSSUG April 2014 Meeting

Session: Intro to Storage Performance

Presenter: Stuart Miller, MCM of SQL Server

 

CPU, Memory, and Disk are the three pillars that keep our databases standing. Most of us comfortably understand CPU and Memory, even if some subtleties like NUMA can be confusing, but Disk is frequently treated like an indecipherable black box particularly when a SAN enters the picture. After some background on the IO pipe, I'll explain how SQL interacts with the storage and provide some key metrics and measurements to look for. I will then explain some of the tools you have available to see how your storage is performing right now as well as how it could be performing, and explain some of the options you have to bridge that gap.

Stuart Miller has been working in IT for 10 years variously as a UNIX Sysadmin, Network Admin, Software Engineer, and now as a SQL DBA. At 28 years old, he is the second youngest Microsoft Certified Master of SQL Server. His specialty is managing sprawl in large, organically-grown environments and bringing order to the chaos.

 

When

iCal
UTC : Wed, Apr 09 2014 23:30 - 01:00
Event Time : Wed, Apr 09 2014 16:30 - 18:00 (UTC-07:00) Arizona
Your Local Time: Wed, Apr 09 2014 23:30 - 01:00

Where

60 E Rio Salado Parkway, 12th Floor
Tempe, Arizona

Direction: None

Featured Presentation

Intro to Storage Performance

Speaker: Stuart Miller, Database Administrator

Summary: CPU, Memory, and Disk are the three pillars that keep our databases standing. Most of us comfortably understand CPU and Memory, even if some subtleties like NUMA can be confusing, but Disk is frequently treated like an indecipherable black box particularly when a SAN enters the picture. After some background on the IO pipe, I'll explain how SQL interacts with the storage and provide some key metrics and measurements to look for. I will then explain some of the tools you have available to see how your storage is performing right now as well as how it could be performing, and explain some of the options you have to bridge that gap.

About Stuart: Stuart Miller has been working in IT for 10 years variously as a UNIX Sysadmin, Network Admin, Software Engineer, and now as a SQL DBA. At 28 years old, he is the second youngest Microsoft Certified Master of SQL Server. His specialty is managing sprawl in large, organically-grown environments and bringing order to the chaos.

Attachments

Meeting Archive

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids