Past Meetup

Introduction to Wait Types and Response Time Analysis

This Meetup is past

57 people went

Location image of event venue

Details

Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.Speaker Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database applications. Before coming to SolarWinds (http://www.solarwinds.com/?gclid=COONzL_1_8ACFcRbfgodLz0AwQ&CMP=KNC-TAD-GGL-NA_BRAND-X-DL&ef_id=UrM4zgAABYGtRzEU:20140926222150:s) (formally Confio), Janis held DBA positions working with both real-time network routing databases and OLTP business to business applications. As a Principal Architect and Senior Manager, Janis has mentored many other DBAs on best practices in database performance tuning.