dbTalk Databases Forums  

Cache Policy , Cache Ratio

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


Discuss Cache Policy , Cache Ratio in the microsoft.public.sqlserver.olap forum.



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

Default Cache Policy , Cache Ratio - 09-08-2005 , 04:34 AM






Does anyone know where I can find informations about

Cache policy,
Cache Ratio ?

What is the meaning of the numbers like 7 or 5 for cache policy?.

In the MS doc is written [reserverd]


My problem is that I have an aplcation wich is changing the fact table then
is triggering an dts to update the cubes and when is finished is reading the
data.
The problem is that the data that is readed is the old one. If I wait for
5-10sec and then I read again, the data is the new, correct one. The dts are
executed syncron, so I wait for the DTS to be finished.




Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Cache Policy , Cache Ratio - 09-08-2005 , 07:35 AM






try to change the "Auto Synch Period" option in the connection string.

http://msdn.microsoft.com/library/de...pgref_3yex.asp



"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote

Quote:
Does anyone know where I can find informations about

Cache policy,
Cache Ratio ?

What is the meaning of the numbers like 7 or 5 for cache policy?.

In the MS doc is written [reserverd]


My problem is that I have an aplcation wich is changing the fact table
then is triggering an dts to update the cubes and when is finished is
reading the data.
The problem is that the data that is readed is the old one. If I wait for
5-10sec and then I read again, the data is the new, correct one. The dts
are executed syncron, so I wait for the DTS to be finished.






Reply With Quote
  #3  
Old   
Radu Colceriu
 
Posts: n/a

Default Re: Cache Policy , Cache Ratio - 09-08-2005 , 07:44 AM



Cache Ratio Property
Reserved for future use







"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Quote:
try to change the "Auto Synch Period" option in the connection string.

http://msdn.microsoft.com/library/de...pgref_3yex.asp



"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message
news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Does anyone know where I can find informations about

Cache policy,
Cache Ratio ?

What is the meaning of the numbers like 7 or 5 for cache policy?.

In the MS doc is written [reserverd]


My problem is that I have an aplcation wich is changing the fact table
then is triggering an dts to update the cubes and when is finished is
reading the data.
The problem is that the data that is readed is the old one. If I wait for
5-10sec and then I read again, the data is the new, correct one. The dts
are executed syncron, so I wait for the DTS to be finished.








Reply With Quote
  #4  
Old   
Jéjé
 
Posts: n/a

Default Re: Cache Policy , Cache Ratio - 09-09-2005 , 06:52 AM



oups...
http://msdn.microsoft.com/library/en...asp?frame=true

"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote

Quote:
Cache Ratio Property
Reserved for future use







"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
try to change the "Auto Synch Period" option in the connection string.

http://msdn.microsoft.com/library/de...pgref_3yex.asp



"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message
news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Does anyone know where I can find informations about

Cache policy,
Cache Ratio ?

What is the meaning of the numbers like 7 or 5 for cache policy?.

In the MS doc is written [reserverd]


My problem is that I have an aplcation wich is changing the fact table
then is triggering an dts to update the cubes and when is finished is
reading the data.
The problem is that the data that is readed is the old one. If I wait
for 5-10sec and then I read again, the data is the new, correct one. The
dts are executed syncron, so I wait for the DTS to be finished.










Reply With Quote
  #5  
Old   
Radu Colceriu
 
Posts: n/a

Default Re: Cache Policy , Cache Ratio - 09-09-2005 , 10:21 AM



thanks,

unfortunatelly i use a tool that doesn't allow me to change/alter the
connection string. it gives me an interface only 4 params:
Cache policy, cache ratio, execution location, isolation mode.

I can't find any doc about what cache ratio and cahce policy parameters
means. I've seen a lot of people using it.



"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:OClarTTtFHA.3316 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Quote:
oups...
http://msdn.microsoft.com/library/en...asp?frame=true

"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message
news:OfS2DLHtFHA.3452 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Cache Ratio Property
Reserved for future use







"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
try to change the "Auto Synch Period" option in the connection string.

http://msdn.microsoft.com/library/de...pgref_3yex.asp



"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message
news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Does anyone know where I can find informations about

Cache policy,
Cache Ratio ?

What is the meaning of the numbers like 7 or 5 for cache policy?.

In the MS doc is written [reserverd]


My problem is that I have an aplcation wich is changing the fact table
then is triggering an dts to update the cubes and when is finished is
reading the data.
The problem is that the data that is readed is the old one. If I wait
for 5-10sec and then I read again, the data is the new, correct one.
The dts are executed syncron, so I wait for the DTS to be finished.












Reply With Quote
  #6  
Old   
Chris Webb
 
Posts: n/a

Default Re: Cache Policy , Cache Ratio - 09-09-2005 , 11:11 AM



Try this webcast:
http://support.microsoft.com/default.aspx?kbid=901162

--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"Radu Colceriu" wrote:

Quote:
thanks,

unfortunatelly i use a tool that doesn't allow me to change/alter the
connection string. it gives me an interface only 4 params:
Cache policy, cache ratio, execution location, isolation mode.

I can't find any doc about what cache ratio and cahce policy parameters
means. I've seen a lot of people using it.



"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:OClarTTtFHA.3316 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
oups...
http://msdn.microsoft.com/library/en...asp?frame=true

"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message
news:OfS2DLHtFHA.3452 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
Cache Ratio Property
Reserved for future use







"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag
news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
try to change the "Auto Synch Period" option in the connection string.

http://msdn.microsoft.com/library/de...pgref_3yex.asp



"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message
news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Does anyone know where I can find informations about

Cache policy,
Cache Ratio ?

What is the meaning of the numbers like 7 or 5 for cache policy?.

In the MS doc is written [reserverd]


My problem is that I have an aplcation wich is changing the fact table
then is triggering an dts to update the cubes and when is finished is
reading the data.
The problem is that the data that is readed is the old one. If I wait
for 5-10sec and then I read again, the data is the new, correct one.
The dts are executed syncron, so I wait for the DTS to be finished.













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.