I like your site verymuch!!
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 aurot 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?