In addition to David's response: DBCC DROPCLEANBUFFERS only flushes clean buffers. To ensure all buffers are clear, you would have to execute a CHECKPOINT. But that would definitely not represent a real life example.
Restricting the assigned memory is definitely a good idea. Whether it is enough, I don't know. For one, a life like example would have multiple threads inserting simultaneously.
Gert-Jan
No comments:
Post a Comment