SQL Server Performance

SP execution in query analyzer is slow

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by helios, Apr 2, 2007.

  1. helios New Member

    When I run a stored procedure in Query Analyzer (exec &lt;spName&gt; &lt<img src='/community/emoticons/emotion-4.gif' alt=';p' />arams&gt<img src='/community/emoticons/emotion-5.gif' alt=';)' /> with its required parameters, it runs in about twenty minutes. But if I run the same select statements of that stored procedure (copy and paste it on query analyzer), it runs about three minutes only. What could be the reasons for this?<br /><br />gwapings
  2. Roji. P. Thomas New Member

  3. helios New Member

    Thanks Roji, it is parameter sniffing thats slowing down my SP. Now my SP runs three minutes also.

    gwapings
  4. satya Moderator

Share This Page