Skip to Content
56:18 線上研討會

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 2022年10月20日
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 解決方案
  • FlashStack
  • FlashArray//X

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.
聯繫我們
問題或建議

如對Pure的產品或認證,有任何的疑問或建議,歡迎與我們聯繫!

預約試用

預約現場示範,親眼看看 Pure 如何幫助您將資料轉化為強大的成果。 

聯絡我們:886-2-3725-7989

媒體:pr@purestorage.com

 

Pure Storage總部

34F, Taipei Nanshan Plaza,

No. 100, Songren Road,

Xinyi District,

Taipei City 110016

Taiwan (R.O.C.)

800-379-7873 (一般資訊)

info@purestorage.com

關閉
您的瀏覽器已不受支援!

較舊版的瀏覽器通常存在安全風險。為讓您使用我們網站時得到最佳體驗,請更新為這些最新瀏覽器其中一個。