Next Meetup

Brent Ozar - Why is the Same Query Sometimes Slow?
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. Brent's bio: Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at http://BrentOzar.com .

Microsoft Cincinnati Office

4445 W Lake Forest Drive Suite 100 · Blue Ash, OH

Respond by: 4/16/2018

    Past Meetups (34)

    What we're about

    Public Group

    CincyPASS is a user group dedicated to enhancing careers of SQL Server (and related technologies too!) professionals through networking and learning. CincyPASS is a PASS affiliated user group.

    We attempt to schedule meetings at 6:30pm on the third Tuesday of each month, and they are open to all individuals who work with all areas of Microsoft's data platform (or are aspiring to do so).

    Meetings typically include an update from PASS HQ along with a featured speaker. We are constantly looking for volunteers to speak, so if you are interested please volunteer.

    Members (307)

    Photos (28)