Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Bad Parameter Sniffing Decision Flow Chart [Infographic]

DZone's Guide to

Bad Parameter Sniffing Decision Flow Chart [Infographic]

Unsure of what to do when you suspect bad parameter sniffing is occurring with your stored procedure? This flowchart can help you deal with it!

· Database Zone
Free Resource

Find out how Database DevOps helps your team deliver value quicker while keeping your data safe and your organization compliant. Align DevOps for your applications with DevOps for your SQL Server databases to discover the advantages of true Database DevOps, brought to you in partnership with Redgate

Lots of people are confused with how to deal with bad parameter sniffing when it occurs. In an effort to help with this, I’m going to try to make a decision flow chart to walk you through the process. This is a rough — quite rough — first draft.

Image title

I would love to hear any input. For this draft, I won’t address the things I think I’ve left out. I want to see what you think of the decision flow and what you think might need to be included. 

Thanks to the attendees at my SQLSaturday Louisville pre-con for the great questions and the inspiration to get this done.

Thank you in advance for any and all feedback.

Align DevOps for your applications with DevOps for your SQL Server databases to increase speed of delivery and keep data safe. Discover true Database DevOps, brought to you in partnership with Redgate

Topics:
parameter sniffing ,sql server ,database ,stored procedures

Published at DZone with permission of Grant Fritchey, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}