Thanks for the reply Sebb. Its working perfectly fine. I checked database cache it is getting cleaned up.
On Wed, Mar 4, 2009 at 5:29 PM, sebb <[email protected]> wrote: > On 04/03/2009, Ravindra Gupta <[email protected]> wrote: > > Hi, > > > > Can we run database clear cache DBCC DROPCLEANBUFFERS using JDBC > request? > > If yes What query type should be selected? Update statemnet? > > I am using SQL server 2005 and Jmeter 2.3.1 > > See below, you have answered your own question. > > > Actually I am able to run DBCC DROPCLEANBUFFERS successfully using > > Jmeter(JDBC request) using query type - Update. > > It shows 0 update in response but I am not sure whether it is being > executed > > successfully or not. > > That means 0 rows were updated. > > It must have been at least partially processed for it to get that far. > > Looks OK to me, but I don't know the database. > > > > Thanks, > > > > Ravindra > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
