Parameter Sniffing

  • How to find permormance issue with repect to Parameter Sniffing? and how to resolve it.

  • Good Article

    http://www.sommarskog.se/query-plan-mysteries.html

    java[/url]

  • Satya_0000 (12/3/2011)


    How to find permormance issue with repect to Parameter Sniffing? and how to resolve it.

    Well...I would start by looking for performance issues in general, and then trying to determine the root cause of the issue (which may be caused by parameter sniffing, or one of a million other things). Parameter sniffing is generally a good thing (except when it isn't), so starting out by trying to locate situations where it's occurring is probably the wrong approach. What is causing you to ask this question? Are you just interested in learning about parameter sniffing issues in general, or have you already identified a poorly performing query and now you're wondering how to figure out if parameter sniffing is what's causing your problems?

  • The chapter I wrote for the MVP Deep Dives 2 book is all on parameter sniffing "Parameter Sniffing, Your Best Friend in the World, Except When It Isn't." I lay out several ways to fix bad sniffing and the pluses & minuses of each solution. I also have a presentation I give called "Seven Solutions for Bad Parameter Sniffing." I presented it at Connections in Vegas. I'll be presenting it at SQL Saturday 104 in Colorado Springs.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply