Performance Zone
Performance Zone is brought to you in partnership with:
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Setup For Performance Testing: Clear Cache, Buffers (MSSQL)

12.07.2005
| 27108 views |
  • submit to reddit 
        For Microsoft SQL (MSSQL).
Use this to clear the cache and buffers to ensure comparison are accurate.


dbcc freeproccache
go
dbcc dropcleanbuffers
go
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers