Sacramento SQL Server User Group

 SQLSaturday Sacramento 2019 is August 17
Attending PASS Summit 2019? Use discount code LGDIS6HUR to save $150 and support our group!

 

Next Meeting

Wednesday,

January

09

Why is the Same Query Sometimes Slow? - Brent Ozar (Remote)

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

Why is the Same Query Sometimes Slow? - Brent Ozar (Remote)

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 BrentOzar.com.

Meeting Sponsor:
Snowflake
https://www.snowflake.com

Sacramento SQL Server User Group
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448

Alternate meeting location, January only:
2180 Harvard Street
Suite 280 (Second Floor)
Sacramento, CA 95815
https://goo.gl/maps/brAJpyPn78Q2

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Our Sponsors

PASSChapterLogo100.jpg

 

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