locked
SQL Server 2008 Plan Cache maintenance RRS feed

  • Question

  • Hi,

    I have a question, please help/suggest me.

    I have a production SQL Server 2008 where there are 4 significant stored procedures running in every 15 seconds(Borwser auto refresh) from different users(100+ users connect to site from diff locations)

    Sometimes there is no data coming from these stored procedures and application is timing out 

    So we are running follwoing queries to resolve the issue in productuion server

    DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE

    Now we are planing to keep this as part of weekend maintenance activity, so please advise what are the parameters we have to check and what is best practices to clear cache?

    Thanks,

    Ali

    Sunday, August 24, 2014 6:47 AM