Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2012-01-07 : 00:27:11
|
| I've question as following,1. What's the situation I've to run DBCC DROPCLEANBUFFERS and FREEPROCCACHE?2. It's good or not to run run DBCC DROPCLEANBUFFERS and FREEPROCCACHE in production environment? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-01-07 : 00:41:26
|
| 1. Typically just for performance testing to get a baseline so that you can make apples to apples comparisons2. You shouldn't need to do it in production. However, there are times when it is necessary. A properly designed system should not need it. We have one particular improperly designed system that requires freeing the procedure on a schedule. We've been able to reduce it by finding the problematic stored procedures, fixing them or by add the recompile option, but we do still need to run it on a schedule. I am working towards eliminating this need though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
wkm1925
Posting Yak Master
207 Posts |
Posted - 2012-01-07 : 00:45:26
|
| tq sir |
|
|
|
|
|
|
Run DBCC DROPCLEANBUFFERS and FREEPROCCACHE