• without the details my friend anthony is asking for, i'd WAG and say to update statistics on the underlying tables the procedure uses.

    out of date statistics are associated witht eh symptom you describe: performance of an existing proc slowly degrades.

    parameter sniffing could also be an issue...more details might be needed, as anthony suggested.

    UPDATE STATISTICS dbo.[Table1] WITH FULLSCAN ;

    UPDATE STATISTICS dbo.[Table2] WITH FULLSCAN ;

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!