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

Join Our Group Online!
http://groups.yahoo.com/group/stlssug

 Receive a $150 discount to the PASS 2014 Summit when you Register with our unique discount code: USNCS35 

Next Meeting

Tuesday,

September

09

STLSSUG September 9, 2014 Meeting

  • In-Person @ Three City Place Drive, Suite 1100 St. Louis, Missouri, United States (map)
  • 13:00 - 17:00 Central Daylight Time
  • Language: English

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. 

http://www.microsoft.com/about/companyinformation/usaoffices/northcentral/stlouis.mspx 

  

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.  

 

Abstract:   

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.

 

 

Abstract:   

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    

https://join.microsoft.com/meet/ehendrix/LF47VQGZ 

 

Join by phone

+13149941870 (USA, Saint Louis)          English (United States)

Find a local number

 

Conference ID: 887676896