ANNOUNCEMENT Pure Storage Introduces The Enterprise Data Cloud So Customers Can Manage Their Data, Not Their Storage
PURE//LAUNCH Discover the unmatched performance density of the next generation of FlashArray//XL, built for your most demanding workloads.
BREAKING NEWS In uncertain times, Evergreen//One™ delivers an economy-proof advantage.
Visit Pure.ai Sales +44 20 3995 0864
Visit Pure.ai Sales +44 20 3995 0864
Choose Your Region
Choose Your Region
The Pure Advantage Solutions Products Services & Support Resources Partners Company
CONTACT US
Lightning bolt icon
Sales (800) 976-6494
Contact Us
Main Menu
The Pure Advantage
Solutions
Products
Services & Support
Resources
Partners
Company
Contact Us
56:18 Webinar

Why is One Query Sometimes Slow and Sometimes Fast?

Sometimes the exact same query goes slow out of nowhere. Your current fix is to update statistics, rebuild indexes, or restart the SQL Server. It works, but you don’t know why.
This webinar first aired on 20 October 2022
The first 5 minute(s) of our recorded Webinars are open; however, if you are enjoying them, we’ll ask for a little information to finish watching.
  • Microsoft SQL & Exchange Solutions
  • FlashStack
  • FlashArray//X

Brent Ozar

Founder/Owner, Brent Ozar Unlimited

The single most common reason is parameter sniffing. SQL Server "sniffs" the first set of parameters for a query, builds an execution plan for it, and then reuses that same plan no matter what parameters get called. It’s been the bane of our performance tuning for decades.

In this session, Brent Ozar explains:

  • How it happens
  • How SQL Server 2022 is trying to fix it and
  • How you can work around emergencies in the meantime

We Also Recommend...

Check Out Our Resource Centre Check Out Our Resource Centre
07/2024
Pure Storage FlashArray//X | Data Sheet
FlashArray//X provides unified block and file storage with enterprise performance, reliability, and availability to power your critical business services.
Data Sheet
5 pages
06/2025
Pure Storage FlashBlade//S | Data Sheet
FlashBlade//S™ is our flagship, all-flash, performance-optimized unified file and object storage platform for your most demanding scale-out storage needs.
Data Sheet
5 pages
02/2022
Embracing the Elephant in the Room: Ever-Shifting Expectations for Disaster Recovery & Business Continuity
Join Andrew Miller and Zane Allyn as they revisit an ageless topic from the first Coffee Break - All Things Data Protection (Disaster Recovery, Business Continuity, Backup & Recover) and how Pure can help..
Webinar
Continue Watching
We hope you found this preview valuable. To continue watching this video please provide your information below.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Your Browser Is No Longer Supported!

Older browsers often represent security risks. In order to deliver the best possible experience when using our site, please update to any of these latest browsers.

safari
chrome
firefox
edge