St. Louis SQL Server User Group Meeting
September 9th 1:00 pm- 4:00 pm
Vendor Presentation 4:15 pm- 5:00 pm
The next St. Louis SQL Server User Group meeting will be on September 9th from 1:00 pm – 4:00 pm with a vendor presentation from 4:00-5:00pm. Please RSVP, so that we can have a count for a lunch order, https://www.eventbrite.com/e/stlssug-september-9-2014-meeting-tickets-12491643843
Also, please feel free to forward this meeting announcement to anyone who may be interested in attending.
This will also be broadcasted as a lync meeting. Lync meeting link is listed below
Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO 63141. Parking is in the garage behind / next to the building. There is an entrance to the building from the 2nd floor in the garage.
Agenda12:30 – 1:00 Registration - Lunch Provided - Solarwinds
1:00 Janis Griffin, Solarwinds – Query Tuning - Get it Right the First Time
2:30 Janis Griffin, Solarwinds – Introduction to Wait Types and Response Time Analysis
4:00 Raffle Drawing – Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly/MS Publishing Books and more!
4:15 Vendor Presentation
Janis Griffin has over 25 yeas of DBA experience including design, development, and implementation of many critical database applications. Before coming to SolarWinds (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.
Title: Query Tuning - Get it Right the First Time
Whether you are a developer or DBA, this presentation will outline a method for determining the best approach for tuning a query every time by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement or database platform being utilized (this method works on all), this quick and systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Introduction to Wait Types and Response Time Analysis
Using Wait Types and Response Time Analysis techniques is a newer and often miused method for tuning SQL Server instances and applications. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the response time data is analyzed at the wrong level and 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 based performance analysis to solve the most difficult performance related issues.
Join Lync Meeting
Join by phone
+13149941870 (USA, Saint Louis) English (United States)
Find a local number
Conference ID: 887676896