Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Proc Cache Question RE: Proc Cache Question

  • October 17, 2012 at 2:22 am

    #1549903

    simon4132-806507 (10/16/2012)

    Hi,

    I totally agree - I am now at the last resort phase!

    We simply cannot have a database which slows down after 3-10 days.

    I have looked at the statistics, but i'm not sure what they are supposed to tell me. There are 2 large tables (10m rows) and the statistics reflect this on those tables.

    However i'm not sure how statistics relate to a slowing down database which speeds up by freeing the proc cache?

    Thanks

    Simon

    If the statistics are wrong you have bad plan and your query is slow.

    Freeing proc cache is kind of restart - the - server solution. You may get back the performance by doing that.

    But how do you confirm that your queries are waiting for memory. What waits do you have on your server?

    I think yoou should thoroughly check cached plans and execution statistics before you look for resource bottleneck

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]