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 Dean Richards, Solarwinds – Query Tuning - Get it Right the First Time
2:30 Dean Richards, 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
Dean Richards is a Manager of Sales Engineering and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize databases while still achieving high performance.
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.