SQL Server Performance

Slow stored procedures

Discussion in 'SQL Server 2008 Performance Tuning for DBAs' started by zimzum, May 18, 2009.

  1. zimzum New Member

    Hi friends... It's me again...
    I need to ask you one simple question this time. Is there som mechanism to get a lot of info when a stored procedure execution lasts more then a given threshold? I have a stored procedures that runs great 99% of the time (not more than 5ms) but from now and then it lasts about 2 or 3 seconds (and sometimes even more). This can happen 2 times a day at most, so I can't leave a Profiler on, because it could create a file so big that would make the server collapse.
    I want to know what happened with that particular execution, so I can see if there is some issue with a index or similar.
    Thanks a lot!
    Zim
  2. FrankKalis Moderator

  3. zimzum New Member

    fine... that looks exactly like what I need... I will give it a try and see how it works. I'll let you know.
    Thanks a lot!
    Zim

Share This Page