CincyPASS

Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4605 Duke Drive, Suite 800, Mason, OH. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 6:30 - Welcome and Announcements
  • 6:45 - Featured Presentation
  • 7:45 - Q&A Session / Door Prizes

 

Next Meeting: Tue, Nov 21 2017

Analyzing I/O Subsystem Performance

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/CincyPASS/events/242211899/

SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator?  Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

Speaker: Glenn Berry has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. He is also an Adjunct Faculty member at University College – University of Denver, where has been teaching since 2000. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.

Sponsor:- Cardinal Solutions

When

iCal
UTC : Tue, Nov 21 2017 23:00 - 01:00
Event Time : Tue, Nov 21 2017 18:00 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Nov 21 2017 23:00 - 01:00

Where

4445 W Lake Forest Drive
Blue Ash, Ohio

Direction: None

Featured Presentation

Analyzing I/O Subsystem Performance

Speaker: Glenn Berry, Principal Consultant SQLskills

Summary: SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.

About Glenn: Glenn Berry works as a principal consultant at SQLskills in Elizabeth, CO. He is a Data Platform MVP and has a collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests! His expertise includes DMVs, high availability, hardware selection, and storage subsystems. Glenn is also an adjunct faculty member at University College - University of Denver, where he has taught since 2000.

Attachments

PASSChapterLogo100.jpg

 

sql_micro_sm.gif

 




 

sql_micro_sm.gif

 

 

 

 

 

 

 

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