|
Home > Archive > ASE Database forum > October 2005 > How to flush data cache
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to flush data cache
|
|
|
| I am trying to benchmark my database I/Os. I thought I could
use a statement like 'select count(*) from tablea (mru)'.
The table is always fully cached on subsequent reads.(About
a 200meg table) How can I flush cache to do repeated
physical reads. I'm trying to compare the performance of two
different database servers.
| |
| Sherlock, Kevin 2005-10-27, 8:21 am |
| sp_unbindcache <dbname>.<owner>.<tablename>
If your table is bound to a named cache other than the "default data cache",
then bind it again after the above command.
sp_bindcache <cachename>,<dbname>.<owner>.<tablename>
If it's "bound" to the "default data cache" then you don't have to do anything
after "sp_unbindcache".
<Steve> wrote in message news:43500937.6eaf.1681692777@sybase.com...
> I am trying to benchmark my database I/Os. I thought I could
> use a statement like 'select count(*) from tablea (mru)'.
> The table is always fully cached on subsequent reads.(About
> a 200meg table) How can I flush cache to do repeated
> physical reads. I'm trying to compare the performance of two
> different database servers.
| |
| Sherlock, Kevin 2005-10-27, 8:21 am |
| Sorry, the syntax for "sp_unbindcache" should read (note the commas):
sp_unbindcache <dbname>,<owner>.<tablename>,<indexname>
"Sherlock, Kevin" <ksherlock@saionline.com> wrote in message
news:43501093$1@foru
ms-1-dub...
> sp_unbindcache <dbname>.<owner>.<tablename>
>
> If your table is bound to a named cache other than the "default data cache",
> then bind it again after the above command.
>
> sp_bindcache <cachename>,<dbname>.<owner>.<tablename>
>
> If it's "bound" to the "default data cache" then you don't have to do anything
> after "sp_unbindcache".
>
> <Steve> wrote in message news:43500937.6eaf.1681692777@sybase.com...
>
>
|
|
|
|
|