Event link at our Meetup page.
- 5:30 pm Networking
- 6:00 pm Meeting
Parameter Sniffing: Everything You Have Been Told is Wrong!
Execution plan reuse is one of the most misunderstood aspects of SQL Server. While it serves us well 99.99% of the time, it is very easy to trip up when parameter sniffing results in performance problems.
In this session, we will thoroughly dissect how plan reuse works, discuss parameter sniffing, and the many potential solutions available to resolve it. We will examine the many poor solutions that are found on blogs and web pages all over the internet and why applying a quick-fix may result in long-term performance headaches if not thoroughly researched prior to implementation.
Ed Pollack has 20+ years of experience in database administration and architecture, which has developed his passion for performance optimization, database design, and security. He has spoken at many SQLSaturdays, 24 Hours of PASS, and PASS Summit. This led him to organize many SQL Saturday and other Microsoft data platform events. Ed is a Microsoft Data Platform MVP.
In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.