Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Intermediate
Nov 30, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Be Sure To Clear SQL Server Cache When Performing Benchmark Tests

When tuning SQL Server applications, a certain degree of hands-on experimenting must occur. Index options, table design, and locking options are items that can be modified to increase performance. When running a test, be sure to have SQL Server start from the same state each time. The cache (sometimes referred to as the buffer) needs to be cleared out. This prevents the data and/or execution plans from being cached, thus corrupting the next test. To clear SQL Server
Andrew Holliday
Thanks for your registration, follow us on our social networks to keep up-to-date