Created yesterday

Active yesterday

Viewed 20 times

1 replies

I've encountered performance issues with stored procedures in SQL Server 2012, which I suspect are due to parameter sniffing. What are effective strategies to mitigate this problem ?

edited yesterday

Thom A

96.4k
11
61
95

created yesterday

Tony Massamba

1 reply

Sorted by:

Thom A

96.4k
11
61
95

RECOMPILE hints immediately spring to mind. Upgrading to a recent (and supported) version that allows for multiple cached plans is another.

Depending on the query, dynamic SQL, logical blocks and UNION (ALL) queries can actually also be good methods.

1d ago

Share perspectives, advice, and insights

Use Discussions to engage in deeper dialogue, have opinion-based conversations, and exchange perspectives about a technical concept. See full Discussions guidelines.

Discussions is different than Q&A

Discussions exists separately from the traditional question-and-answer space. If you have a specific programming question, go to Stack Overflow Q&A to post your question.

Be welcoming and patient

All users are expected to treat one another with kindness and respect. Remember, everyone is here to learn, and sometimes while learning, people make mistakes. See code of conduct.

No resume or job listings

Discussions are not for sharing your resume or job listing.

Avoid self-promotion

If your post happens to be about your product or website, you must disclose your affiliation. See spam guidelines and best practices.

Collectives™ on Stack Overflow

Parameter Sniffing Workarounds in SQL Server 2012

1 reply