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:
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.
ピュア・ストレージ製品および認定についてのご質問・ご相談を承っております。ご連絡をお待ちしております。
ライブデモのご用命を承っております。ピュアがいかにしてデータを成果に変えるお手伝いができるかをご説明します。
ピュア・ストレージ・ジャパン株式会社
〒100-0014 東京都千代田区永田町 2 丁目 10-3 東急キャピトルタワー 12 階
一般: info-japan@purestorage.com
メディア: pr-japan@purestorage.com
03-4563-7443(総合案内)