Turning Off the PTS Cache 
Author Message
 Turning Off the PTS Cache

I think I've read some where that the size of the PTS
cache on a client connecting to Analysis Services can be
tuned via a registry setting.  Does anyone know what that
setting might be?  And can it be tuned such that the PTS
cache is effectively turned off (or 0)?  Doing some
testing and I want to dial-out the effects of the local
PTS cache on queries...

Thanks!
Dave Fackler



Sun, 10 Jul 2005 21:20:18 GMT
 Turning Off the PTS Cache

Hi Dave,

I think you're referring to the 'Client Cache Size' connection string
property, which is documented in Books Online. However, if you're doing
testing and want to make absolutely sure that client side caching doesn't
have an impact on your results, I'd suggest the best way of doing it is to
open and close your connection before you run each query. Reasons for saying
this include the fact that the documentation suggests that there is no way
of having no cache at all on the client, and that I believe that the Client
Cache Size property doesn't have an influence on the size of the formula
cache, which caches the results of calculated members (but I'm not certain
about this).

HTH,

Chris

--

Chris Webb
Consultant, Microsoft Services Switzerland
(to email: remove 'online.' from the address this was posted with)

Microsoft Services Switzerland and our partners can help you with your
Analysis Services project!

Disclaimer: This posting is provided 'AS IS' with no warranties, and confers
no rights.


Quote:
> I think I've read some where that the size of the PTS
> cache on a client connecting to Analysis Services can be
> tuned via a registry setting.  Does anyone know what that
> setting might be?  And can it be tuned such that the PTS
> cache is effectively turned off (or 0)?  Doing some
> testing and I want to dial-out the effects of the local
> PTS cache on queries...

> Thanks!
> Dave Fackler



Sun, 10 Jul 2005 21:45:47 GMT
 Turning Off the PTS Cache
So, using the following code should set the client cach to
100KB:

    Set cnOLAPServer = New ADODB.Connection
    With cnOLAPServer
        .ConnectionString = "Provider=MSOLAP;Data Source="
& strOLAPServer & ";Initial Catalog=" & strOLAPDatabase
& ";Client Cache Size=100"
    End With
    cnOLAPServer.Open

Running my test queries (opening and closing the
connection before/after each query as you've suggested)
seems to return the same query times with and without
the "Client Cache Size=100" setting.  Does that sound
right??

Thanks,
Dave F.

Quote:
>-----Original Message-----
>Hi Dave,

>I think you're referring to the 'Client Cache Size'
connection string
>property, which is documented in Books Online. However,
if you're doing
>testing and want to make absolutely sure that client side
caching doesn't
>have an impact on your results, I'd suggest the best way
of doing it is to
>open and close your connection before you run each query.
Reasons for saying
>this include the fact that the documentation suggests

that there is no way
Quote:
>of having no cache at all on the client, and that I

believe that the Client
Quote:
>Cache Size property doesn't have an influence on the size
of the formula
>cache, which caches the results of calculated members

(but I'm not certain
Quote:
>about this).

>HTH,

>Chris

>--

>Chris Webb
>Consultant, Microsoft Services Switzerland
>(to email: remove 'online.' from the address this was
posted with)

>Microsoft Services Switzerland and our partners can help
you with your
>Analysis Services project!

>Disclaimer: This posting is provided 'AS IS' with no

warranties, and confers

- Show quoted text -

Quote:
>no rights.



>> I think I've read some where that the size of the PTS
>> cache on a client connecting to Analysis Services can be
>> tuned via a registry setting.  Does anyone know what
that
>> setting might be?  And can it be tuned such that the PTS
>> cache is effectively turned off (or 0)?  Doing some
>> testing and I want to dial-out the effects of the local
>> PTS cache on queries...

>> Thanks!
>> Dave Fackler

>.



Sun, 10 Jul 2005 22:20:11 GMT
 Turning Off the PTS Cache

Yes, that sounds reasonable to me. Opening and closing the connection clears
the client-side cache; so that whichever value you set the Client Cache Size
property to it's irrelevant - there's nothing in the cache when you run your
(single) query, because it will always be the first one after you have
opened a connection, and so the cache will always be empty. You'd only see
the effects of caching when you ran a second query after the first on the
same connection, which requested some or all of the same data.

What are you trying to test? Do you realise that caching takes place on the
server too, or are you only interested in the client cache here?

Regards

Chris

--

Chris Webb
Consultant, Microsoft Services Switzerland
(to email: remove 'online.' from the address this was posted with)

Microsoft Services Switzerland and our partners can help you with your
Analysis Services project!

Disclaimer: This posting is provided 'AS IS' with no warranties, and confers
no rights.


Quote:
> So, using the following code should set the client cach to
> 100KB:

>     Set cnOLAPServer = New ADODB.Connection
>     With cnOLAPServer
>         .ConnectionString = "Provider=MSOLAP;Data Source="
> & strOLAPServer & ";Initial Catalog=" & strOLAPDatabase
> & ";Client Cache Size=100"
>     End With
>     cnOLAPServer.Open

> Running my test queries (opening and closing the
> connection before/after each query as you've suggested)
> seems to return the same query times with and without
> the "Client Cache Size=100" setting.  Does that sound
> right??

> Thanks,
> Dave F.

> >-----Original Message-----
> >Hi Dave,

> >I think you're referring to the 'Client Cache Size'
> connection string
> >property, which is documented in Books Online. However,
> if you're doing
> >testing and want to make absolutely sure that client side
> caching doesn't
> >have an impact on your results, I'd suggest the best way
> of doing it is to
> >open and close your connection before you run each query.
> Reasons for saying
> >this include the fact that the documentation suggests
> that there is no way
> >of having no cache at all on the client, and that I
> believe that the Client
> >Cache Size property doesn't have an influence on the size
> of the formula
> >cache, which caches the results of calculated members
> (but I'm not certain
> >about this).

> >HTH,

> >Chris

> >--

> >Chris Webb
> >Consultant, Microsoft Services Switzerland
> >(to email: remove 'online.' from the address this was
> posted with)

> >Microsoft Services Switzerland and our partners can help
> you with your
> >Analysis Services project!

> >Disclaimer: This posting is provided 'AS IS' with no
> warranties, and confers
> >no rights.



> >> I think I've read some where that the size of the PTS
> >> cache on a client connecting to Analysis Services can be
> >> tuned via a registry setting.  Does anyone know what
> that
> >> setting might be?  And can it be tuned such that the PTS
> >> cache is effectively turned off (or 0)?  Doing some
> >> testing and I want to dial-out the effects of the local
> >> PTS cache on queries...

> >> Thanks!
> >> Dave Fackler

> >.



Sun, 10 Jul 2005 23:04:31 GMT
 Turning Off the PTS Cache
Quote:
> I believe that the Client Cache Size property doesn't have an influence on

the size of the formula

Quote:
> cache, which caches the results of calculated members (but I'm not certain
> about this).

This was true until SP3, but in there was a SP2 QFE (which was rolled in
into SP3) where this was fixed.

--
==================================================
Mosha Pasumansky (moshap at microsoft dot com)
Development Lead in the Microsoft Analysis Server team
More info at http://www.mosha.com/msolap
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================



Mon, 11 Jul 2005 03:54:24 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. PTS Caching and PTS Monitoring

2. Turning cache off on a Seagate drive under AIX - Progress/AIX/Seagate don't mix

3. Possible to turn off file system cache?

4. Possible to turn off file system cache?

5. turn write-to-cache off

6. Possible to turn off file system cache?

7. Performance Testing ( Turn compile cache off ? )

8. Turning off cache for a single sql-query

9. SQL Server & turning RAID Cache Off

10. Can I turn OFF read cache?

11. Turn it off, turn it on

12. PTS Client side cache


 
Powered by phpBB® Forum Software