L.A. SQL Server Professionals Group

Welcome to the Los Angeles SQL Server Professionals Group

Next Meeting

Thursday,

July

20

Part 1: Introduction to SQL Server on Linux, Part 2: Understanding Parameter Sniffing

  • In-Person @ 10250 Santa Monica Blvd. Los Angeles, California, United States (map)
  • 18:30 - 21:00 Pacific Daylight Time
  • Language: English

L.A. SQL Server Professional Group Meeting

Featured Presentation:

Part 1: Introduction to SQL Server on Linux, Part 2: Understanding Parameter Sniffing

Benjamin Nevarez SQL Server Consultant

Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.

About Benjamin:
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning & Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals." Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids