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
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.
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.