Performance issue

• rafa.aborges

  Default port

  Points: 1430

  More actions

  August 31, 2009 at 12:30 pm

  #210149

  Hi,

  I'm facing an unusual performance issue on SQL Server 2000.

  I'm running a query without using any variable, just using explicit values on the where clause and the query runs in 2 seconds.

  When I try to run using variables, the performance is very poor, running in 2 minutes. I checked the execution plan and they are different.

  Can you guys help me out with this?

  I'll send the execution plan and the IO Statistics on the next post.

  Thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 31, 2009 at 12:32 pm

  #1047046

  Take a look for "parameter sniffing" online. Gail Shaw's blog has a great article on it. (Blog URL is http://sqlinthewild.co.za/)

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• rafa.aborges

  Default port

  Points: 1430

  More actions

  August 31, 2009 at 12:32 pm

  #1047047

  Ok, I'll check the article!

  Thanks for the reply!