SQL Server Performance

Neverending Procedure

Discussion in 'T-SQL Performance Tuning for Developers' started by tolejar, Aug 16, 2007.

  1. tolejar New Member

    Hi,
    I have a problem with one procedure stored in database. Sometimes when I run it, it goes normally. But 2 from 5 times it behaves as neverending. I logged it and I found out that first select command of procedure behave as neverending. I really don't know why is that.
    Pls help me
    tom[:'(]

  2. satya Moderator

    Best to check the execution plan for that Stored procedure, also try to compile for an upto date plan storage to pick up next time it runs.

Share This Page