dbTalk Databases Forums  

help!: server side query caching

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss help!: server side query caching in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
groove_sf
 
Posts: n/a

Default help!: server side query caching - 07-01-2003 , 10:46 AM






[I'm re-posting this in the hopes that someone will respond ]

i'm new to OLAP on Analysis Service.

i'm working on an OLAP project for my company and i'm doing
performance testing of query times so i obviously need full and clear
control over all types of query caching.

i know that the server does some query caching, but what i want to
know is how to clear it and control its behaviour.

i've read that you can clear the *client* cache (PTS) with:

REFRESH CUBE [MyCubeName]

but does this also reset the server cache? doesn't seem to.

and i've also read that you can clear the *server* cache by resetting
the MS OLAP service (Win2K or XP). is this true? this method seems
to work for me (i.e. i observer that query times slow down for a
period after i reset the MS OLAP service and then they speed up again
after some amount of querying).

are there other ways to reset the server cache? i do know that any
type of cube processing (incremental, full, refresh) seems to reset
the cache.

also, how does the "CACHE" MDX keyword relate to all this? thanks!

also -- can someone point me to *any* documentation about server-side
caching with MS Analysis Services. the more detail the better.

thanks very much!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.