Monday, March 12, 2012

How to find out parameter sniffing problem in SQL server??

Hi,
The database on which I am working, have 220 stored procedures.
I have to find out the procedures those have parameter sniffing problems. How I can find out?
Have any methode to find out this parameter snifffing problem.Look for procedures that use optional parameters, or use parameters to filter columns that have uneven data distribution.
Or, just look for procedures that have inconsistent execution times.

No comments:

Post a Comment