Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Test performance (clear cache etc.)

5 posts in General Discussion Last posting was on 2003-07-17 13:37:21.0Z
Erik Huisman Posted on 2003-07-14 14:50:47.0Z
From: "Erik Huisman" <erik.huisman@spam.ishbv.com.no>
Subject: Test performance (clear cache etc.)
Date: Mon, 14 Jul 2003 16:50:47 +0200
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <eNsd7hhSDHA.342@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: p30113.net.upc.nl 212.142.30.113
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1327
Article PK: 3564

Hello,

I'm doing some performance test with our application.
To make the test results reprodusable without closing database server and
starting again, are there sql statements to force a checkpoint, clear the
cache of the server.
For MS SqlServer i'm using
CHECKPOINT
DBCC DROPCLEANBUFFERS
DBCC FREPROCCACHE
GO

Erik Huisman


Glenn Paulley Posted on 2003-07-14 19:27:16.0Z
Date: Mon, 14 Jul 2003 15:27:16 -0400
From: Glenn Paulley <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: iAnywhere Solutions
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.2.1) Gecko/20021130
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Test performance (clear cache etc.)
References: <eNsd7hhSDHA.342@forums-2-dub>
In-Reply-To: <eNsd7hhSDHA.342@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <OiiAb8jSDHA.342@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: paulley-xp.sybase.com 172.31.141.96
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1328
Article PK: 3563

If you're running 8.x you can use the stored procedure sa_flush_cache().

Glenn

Erik Huisman wrote:
> Hello,
>
> I'm doing some performance test with our application.
> To make the test results reprodusable without closing database server and
> starting again, are there sql statements to force a checkpoint, clear the
> cache of the server.
> For MS SqlServer i'm using
> CHECKPOINT
> DBCC DROPCLEANBUFFERS
> DBCC FREPROCCACHE
> GO
>
> Erik Huisman
>
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer


Robert Waywell Posted on 2003-07-15 14:39:22.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <eNsd7hhSDHA.342@forums-2-dub>
Subject: Re: Test performance (clear cache etc.)
Date: Tue, 15 Jul 2003 10:39:22 -0400
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <#Br6OAuSDHA.349@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1336
Article PK: 3570

Glenn has pointed you to the right tool to clear the cache.

My question is whether you have a reason to believe that your application
will normally and regularly run this query "cold", meaning that none of the
required database pages will be in cache. If not, then a comparison of cold
times could be quite misleading (regardless of the product you are
benchmarking).

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Erik Huisman" <erik.huisman@spam.ishbv.com.no> wrote in message
news:eNsd7hhSDHA.342@forums-2-dub...
> Hello,
>
> I'm doing some performance test with our application.
> To make the test results reprodusable without closing database server and
> starting again, are there sql statements to force a checkpoint, clear the
> cache of the server.
> For MS SqlServer i'm using
> CHECKPOINT
> DBCC DROPCLEANBUFFERS
> DBCC FREPROCCACHE
> GO
>
> Erik Huisman
>
>


Erik Huisman Posted on 2003-07-16 14:08:02.0Z
From: "Erik Huisman" <erik.huisman@spam.ishbv.com.no>
References: <eNsd7hhSDHA.342@forums-2-dub> <#Br6OAuSDHA.349@forums-2-dub>
Subject: Re: Test performance (clear cache etc.)
Date: Wed, 16 Jul 2003 16:08:02 +0200
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <eJtZaT6SDHA.298@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: p30113.net.upc.nl 212.142.30.113
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1356
Article PK: 3592

Robert,

Normally our application will not run this query "cold". Just want to
optimize the sqlstatements sent to the server, for example the join
sequence, where statements using 'IN' compared to equals X or equals Y or
equals Z.

Erik Huisman

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:#Br6OAuSDHA.349@forums-2-dub...
> Glenn has pointed you to the right tool to clear the cache.
>
> My question is whether you have a reason to believe that your application
> will normally and regularly run this query "cold", meaning that none of
the
> required database pages will be in cache. If not, then a comparison of
cold
> times could be quite misleading (regardless of the product you are
> benchmarking).
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Erik Huisman" <erik.huisman@spam.ishbv.com.no> wrote in message
> news:eNsd7hhSDHA.342@forums-2-dub...
> > Hello,
> >
> > I'm doing some performance test with our application.
> > To make the test results reprodusable without closing database server
and
> > starting again, are there sql statements to force a checkpoint, clear
the
> > cache of the server.
> > For MS SqlServer i'm using
> > CHECKPOINT
> > DBCC DROPCLEANBUFFERS
> > DBCC FREPROCCACHE
> > GO
> >
> > Erik Huisman
> >
> >
>
>


Robert Waywell Posted on 2003-07-17 13:37:21.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
References: <eNsd7hhSDHA.342@forums-2-dub> <#Br6OAuSDHA.349@forums-2-dub> <eJtZaT6SDHA.298@forums-2-dub>
Subject: Re: Test performance (clear cache etc.)
Date: Thu, 17 Jul 2003 09:37:21 -0400
Lines: 106
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <ekRM8mGTDHA.344@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: rwaywell-pc.sybase.com 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1369
Article PK: 3602

Since the queries will be run against a 'warm' cache in production then you
definitely want to test that way when you are benchmarking.

By the way, using a simple example with 3 OR clauses all referencing the
same column, we will convert the OR clauses to an IN-list. I tried this with
8.0.2 using asademo.db and this query:

select * from employee
where emp_id = 102
or emp_id = 453
or emp_id = 1576



--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Erik Huisman" <erik.huisman@spam.ishbv.com.no> wrote in message
news:eJtZaT6SDHA.298@forums-2-dub...
> Robert,
>
> Normally our application will not run this query "cold". Just want to
> optimize the sqlstatements sent to the server, for example the join
> sequence, where statements using 'IN' compared to equals X or equals Y or
> equals Z.
>
> Erik Huisman
>
> "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> news:#Br6OAuSDHA.349@forums-2-dub...
> > Glenn has pointed you to the right tool to clear the cache.
> >
> > My question is whether you have a reason to believe that your
application
> > will normally and regularly run this query "cold", meaning that none of
> the
> > required database pages will be in cache. If not, then a comparison of
> cold
> > times could be quite misleading (regardless of the product you are
> > benchmarking).
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Erik Huisman" <erik.huisman@spam.ishbv.com.no> wrote in message
> > news:eNsd7hhSDHA.342@forums-2-dub...
> > > Hello,
> > >
> > > I'm doing some performance test with our application.
> > > To make the test results reprodusable without closing database server
> and
> > > starting again, are there sql statements to force a checkpoint, clear
> the
> > > cache of the server.
> > > For MS SqlServer i'm using
> > > CHECKPOINT
> > > DBCC DROPCLEANBUFFERS
> > > DBCC FREPROCCACHE
> > > GO
> > >
> > > Erik Huisman
> > >
> > >
> >
> >
>
>