axaptafreak: Clear SQL Cache

[Blog bot]

Источник: http://axaptafreak.blogspot.com/2007...sql-cache.html
==============

When you do performance tests in Dynamics AX, you often want to clear the SQL cache so you can be sure that all data must be re-read from the disks.
If you want to clear the SQL cache, execute these 3 lines in a query window:

CHECKPOINT
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
DBCC FREEPROCCACHE WITH NO_INFOMSGS
Helmut Wimmer


Источник: http://axaptafreak.blogspot.com/2007...sql-cache.html