What is Parameter Sniffing?

• SQL2016

  SSC Eights!

  Points: 990

  More actions

  August 7, 2008 at 9:25 am

  #70632

  hi,

  I want to know what is Parameter sniffing , I read from one article, but i got confused, i am used to read new concepts in article, please tell me what is this and use of this..

  Thanks in advance..

  Milu.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 7, 2008 at 10:05 am

  #854572

  Read through these three and see if they help. If you have questions afterwards, plelase ask.

  http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

  http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

  http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• IN_Sandeep

  SSCertifiable

  Points: 6259

  More actions

  August 8, 2008 at 12:31 am

  #854925

  Milu,

  Addition to gail's post, check this too..

  http://pratchev.blogspot.com/2007/08/parameter-sniffing.html

  Cheers!

  Sandy.

  --

• SQL2016

  SSC Eights!

  Points: 990

  More actions

  August 8, 2008 at 9:45 am

  #855325

  Thanks..

  luv's

  Milu.:)

• raj acharya

  SSCrazy

  Points: 2805

  More actions

  December 30, 2008 at 5:22 am

  #918941

  hi, thanx for giving new ideas and new topics i am also fond of new topics and idea ... please post me whenever you find new things and you are also welcome to share your problems with me.

  Raj Acharya