Skip to Content
56:18 Seminarios web

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.
Este webinar se emitió por primera vez el 20 de octubre de 2022
Los primeros 5 minutos de nuestros Webinars grabados son abiertos. Sin embargo, si los está disfrutando, le pediremos un poco de información para terminar de verlos.
  • FlashStack
  • FlashArray//X
  • Soluciones de Microsoft SQL y Exchange

Brent Ozar

Managing Director, Brent Ozar Unlimited

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.

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 will explain:

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

 

We look forward to this exciting webinar!

 

Be one of the first 200 to register and attend the entire webinar, we will send you a $10 gift card for lunch of your choice. Participants who attend and participate in the Event will be entered into a random drawing that will be conducted during or after the Event. The winner of the random drawing will receive one (1) HomeLabs Air Purifier (approx. value $120). The winning Participant will be identified during the Event or within a reasonable amount of time after the Event.

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.
CONTACTAR CON NOSOTROS
¿Preguntas, comentarios?

¿Tiene alguna pregunta o comentario sobre los productos o las certificaciones de Pure?  Estamos aquí para ayudarle.

Programe una Demostración

Programe una demostración en vivo y vea personalmente cómo Pure puede ayudarle a convertir sus datos en unos resultados potentes. 

Llámenos al: +34 51 889 8963

Medios de comunicaciónpr@purestorage.com

 

Castellana 81

28046 Madrid

Oficinas Pure: 1415 y 1417 (planta 14)

info@purestorage.com

CERRAR
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.