BRSSUG - Meeting - April 2014

Topic: Wait Stats: What Are They and Why You Should Care!

Date: Wednesday, April 9, 2014

Location: The Louisiana Technology Park

Sponsored By: Devart - devart.com

Agenda:

  • 5:45 - 6:15 pm: Networking and Refreshments
  • 6:15 - 6:30 pm: Announcements
  • 6:30 - 8:00 pm: Main Topic Speaker

Topic: Wait Stats: What Are They and Why You Should Care!

Speaker: Adrian Aucoin, Corporate Services

Presentation Summary: At some point everyone gets asked the question "why is my system so slow?", hopefully you can take away from this session an understanding and maybe a roadmap of how you could answer that question better in the future.

Presentation Abstract: Many Application Support personnel, IT support, and even some DBA's are occasionally bombarded with "My application is slow", "the database keeps timing out", and many other end user complaints when supporting applications in any industry. Instead of simply blaming it on the developers or simply brushing it off as a "vendor problem", wouldn't it be nice to understand the issues and notify the correct party? This presentation is intended as a primer for wait stats. Introducing the concepts, discussing why it's useful, then discussing a few ways that you can take this knowledge and apply it using a number of different approaches. At the end I've also provided some examples of various LIVE environments I help manage so we can discuss what issues may or may not be prevalent.

Speaker Bio: Adrian Aucoin Jr is a database enthusiast with 9+ years of experience supporting SQL Server and associated applications. He holds a Bachelor's Degree in Computer Science from UL Lafayette. Currently employed with Corporate Services, LLC., where he wears many hats from accidental DBA, development consultant, support team lead, and member of the operations management team. He loves getting involved in SQL related personal and professional events, he has attended the last 3 PASS Summits, volunteered for the last 2 SQL Saturday Baton Rouge's, and participate/attend in multiple PASS virtual chapters.

Contact Us

You can contact us in any of the following ways:

Twitter: @acadianaSQL

Email: info@acadianasql.org