question

vivekchandra09 avatar image
vivekchandra09 asked

load test: the vendor wants to disable the cache

What will be the effect of disabling the cache? My load test vendor wants the run their load test after disabling the cache. Is running DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE at the beginning of the query is the process to disable the cache?
testingtestplan-cachecachedisabled
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
David Wimbush avatar image
David Wimbush answered
Those will clear the data and plan caches. I don't think you can disable them but I imagine they meant 'clear'. Of course, this will have a significant negative effect on the server while it re-compiles incoming batches and fetches the required data from disk.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.