August 22, 2008 at 8:06 am
I'm trying to do some minimal performance testing.
My original plan was to load a particular batch into my application, perform some processing on the batch, and then close the batch, timing how long it took to take each step. Finally, I would close my application. Then, I was going to modify the network connection and perform the same steps on the same batch (after restoring it to its original state).
Here's my question: Does SQL Server 2005 keep the data in the cache between different connections to the database? The reason I ask is that I increased the latency of the network, but my load times are improving.
If SQL Server 2005 does maintain the data cache between connections, is there a way to clear it before I open the application the second time?
Thank you.
Steve Eckhart
August 22, 2008 at 8:12 am
Yes, the cache is shared for both data and procedures.
Run DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS to clear the procedure and data cache between executions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply