St. Louis SQL Server User Group

Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!

PASS Summit 2019 Seattle, WA November 6-8
Use code LGDIS7RW6 to receive a $150 discount off your PASS Summit 2019 registration



Next Meeting




STLSSUG September 9, 2014 Meeting

  • In-Person @ 3 City Place Drive, 11th Floor, Room #2 St. Louis, Missouri, United States (map)
  • 13:00 - 17:00 Central Daylight Time
  • Language: English

Supplementary Materials

The following event attachments are available to you:

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, 


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




Back to Top