Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Clear cache in silent mode

Apr 25 2012 12:00AM by Adam Tokarski   

I just was making some performance tests with some batches going one by one, that was returning only times of durations.

At start of every batch I called statements for cold start, so - in result - it added doubled

DBCC execution completed. If DBCC printed error messages, contact your system administrator." 

for every batch.

So, I found, that there is possibility to call it in silent mode by use WITH NO_INFOMSGS clause:

DBCC FREEPROCCACHE WITH NO_INFOMSGS
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
Read More..   [32134 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Adam Tokarski
58 · 3% · 1021
16
 
6
 
11
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

2  Comments  

  • Thanks. Good to know !

    commented on Apr 25 2012 6:20PM
    rwillemain
    668 · 0% · 50
  • This is good stuff and voted a "Like this", though when testing, I normally like the visual reminders that these things have occured so I can remember to remove them before I move the code to production. ;-)

    commented on May 30 2012 8:06PM
    Jeff Moden
    159 · 1% · 305

Your Comment


Sign Up or Login to post a comment.

"Clear cache in silent mode" rated 5 out of 5 by 16 readers
Clear cache in silent mode , 5.0 out of 5 based on 16 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]