IO, IO! Why is my SQL so slow? Storage I/O Impact on SQL Server Performance

Webcast Overview
 

Disk I/O can be a significant performance bottleneck for SQL Server. And when physical I/O is the suspected culprit, the first thought is to purchase more storage. But expensive hardware upgrades don’t necessarily ensure a faster database. So how do you determine how much I/O is contributing to poor performance? How can you assess the performance of a specific workload on different types of storage? And how do you decide which infrastructure is best for a specific storage solution?

Back by popular demand, please join database performance expert and SolarWinds Product Manager, Brian Flynn, for this presentation to learn the fundamentals of SQL Server storage and how it impacts performance, including:

• The difference between latency, throughput, IOPS, and how they relate
• Performance characteristics of several storage solutions
• Techniques for analyzing storage subsystem performance
• And, how database design and infrastructure interact and impact performance and scalability

Event Registration

Rate and Comment
  Confirm Conference Registration Selection
 
IO, IO! Why is my SQL so slow? Storage I/O Impact on SQL Server Performance
EVENT is Closed
Rate and Comment
Rate and Comment
  Please Confirm Your Information

Rate and Comment


Speakers

    Brian Flynn

    Brian Flynn, Product Manager at SolarWinds, has held roles in multiple disciplines from desktop support to development, administration and systems engineering with web, database, mail and networking technologies. He’s served as a technical contributor and a manager. Over the years, Brian’s also developed custom solutions for monitoring IT systems to diagnose and resolve complex performance problems.

    Lynn Holdheide

    American Institutes for Research (AIR)

    Lynn Holdheide, Ph.D., is a principal TA consultant at American Institutes for Research (AIR) with more than 10 years of experience in providing responsive TA of the highest quality to State educational agencies (SEAs) and regional comprehensive centers. Currently, she leads the Center on Great Teachers and Leaders at AIR as well as the Education Policy Center at AIR. In her previous role as a Vanderbilt University research associate for the National Comprehensive Center for Teacher Quality, she spearheaded efforts to address the pressing challenges in evaluating teachers of students with special needs and served as a reviewer of the U.S. Department of Education’s Elementary and Secondary Education Act flexibility waiver applications in 2012. She also coordinated the TQ Connection, an online resource designed to serve both general and special education teacher preparation. With experience as a special education teacher, project coordinator, and education consultant for nine years at the Indiana Department of Education’s Division of Exceptional Learners, Ms. Holdheide is sensitive to the needs of teachers of students with disabilities and has a deep understanding of the challenges that SEAs face in education reform.

Conference Registration

  • Your registration includes:

    On-demand viewing for 30 days following the event

    Access to the virtual event video content

    Not sure you can attend? No problem, all the video content will be available on-demand for 30 days.