CincyPASS

Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4445 W Lake Forest Drive, Suite# 100, Blue Ash, OH 45242. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 5:30 - Networking and Food
  • 6:00 - PASS news and Announcements
  • 6:15 - Featured Presentation
  • 7:15 - Q&A Session / Door Prizes

 

Next Meeting: Tue, Apr 17 2018

Brent Ozar - Why is the Same Query Sometimes Slow?

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/CincyPASS/events/247749914/

.

When

iCal
UTC : Tue, Apr 17 2018 21:30 - 23:30
Event Time : Tue, Apr 17 2018 17:30 - 19:30 Eastern Daylight Time
Your Local Time: Tue, Apr 17 2018 21:30 - 23:30

Where

4445 W Lake Forest Drive
Blue Ash, Ohio

Direction: None

Featured Presentation

Why is the Same Query Sometimes Slow?

Speaker: Brent Ozar, Microsoft Certified Master of SQL Server Brent Ozar Unlimited

Summary: Why is the Same Query Sometimes Slow? You swear nothing has changed, but all of a sudden, out of nowhere, queries that used to be fast are suddenly slow. Even weirder, you take the slow query from the application, run it in SSMS, and it's totally fast! What's going on? You restart SQL Server or update statistics, and the problem seems to go away - but only for a few days or weeks, and then it comes right back. You're familiar enough with execution plans to realize that you're getting different plans, but...why? And how do you fix it long term? In this session, you'll see live demos of the most common culprit: parameter sniffing. You'll learn how to recognize parameter sniffing when it strikes, understand what causes it, see how to fix it short term with the lowest impact possible, and learn 7 ways to fix it long term. To get the most out of this session, you should have already watched the free online class How to Think Like the Engine, and be familiar with using SET STATISTICS IO ON to see logical reads.

About Brent: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit. He loves sharing knowledge at BrentOzar.com.

Attachments

PASSChapterLogo100.jpg

 

sql_micro_sm.gif

 




Back to Top
cage-aids
cage-aids
cage-aids
cage-aids