What's Happening?

Next Meeting: Fri, Jun 13 2014

June ABQSQL Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

Monthly Meeting

When

iCal
UTC : Fri, Jun 13 2014 17:30 - 19:00
Event Time : Fri, Jun 13 2014 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Jun 13 2014 17:30 - 19:00

Where

6700 Jefferson Street
Albuquerque , New Mexico

Direction: None

Featured Presentation

I Don’t Know Which Queries Are Slow, Just Make Them All Faster

Speaker: Rick Lowe, Principal Development DBA Data FLowe Solutions LLC

Summary: Shortly after learning how to troubleshoot a poorly performing queries it's not unusual for a DBA to discover a nasty surprise - some (or perhaps most) of your users will not be able to actually tell you what query is performing poorly. The good news is that SQL Server does know! Half of this talk lays out the case for why all DBAs should care about the procedure cache (for those who already do care, come to get tips on how to have this discussion with junior staff!). The second half covers some of the basics of looking through the plan cache for slow queries, including some tips on spotting potential parameter sniffing issues when you don't have the luxury of actual execution plans.

About Rick: Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He started his career as a database developer, but over time became more and more interested in how the database engine operated ... eventually becoming more interested in the SQL Server engine than writing code. Since then he has pivoted, become more focused on operational issues, and for the past several years has been a SQL Server performance DBA ... who will write code if he really has to. Rick is an independent consultant currently based in Denver, CO where he primarily focuses on performance tuning and developer education.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.sqlpass.org/.