Re: Caching of Data in IIS / PTS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Akshai Mirchandani [MS] (akshaim_at_online.microsoft.com)
Date: 10/18/04 

Date: Mon, 18 Oct 2004 13:04:19 -0700

Hi Marcus,

This may happen if you have set the Auto Synch Period on the connection
string in the datasources.xml file to a large number. This property controls
how often the PTS checks when the data in the cache is dirty. See BoL
documentation below:

HTH,
Akshai 

--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
Auto Synch Period Property
This property controls the frequency (in milliseconds) of client/server
synchronization.
Property Name
Auto Synch Period
Property ID
DBPROP_MSMD_AUTOSYNCHPERIOD
Remarks
The default is 10,000 milliseconds (10 seconds).
When this property is set to a NULL value or 0 (zero), automatic
synchronization is turned off. Synchronization occurs only when you send a
query to the server.
Because some client queries are resolved solely from the client cache, too
high a value in this property can result in query results that do not
reflect recent updates in the data source. However, too low a value can
impede performance. The lowest valid nonzero value is 250 milliseconds. If a
value between 1 and 249 (inclusive) is specified, a value of 250
milliseconds is used.
You will usually set the value of this property when you establish a
session; however, you can change its value during the session if necessary
"Marcus" <moc456@yahoo.com> wrote in message
news:90d120c7.0410180423.5f9ab2cf@posting.google.com...
> Hi All,
>
> I am coming across an issue with caching of data in IIS / PTS, which
> results in old data being returned in an XML/A query after the cube is
> reprocessed.
>
> If I run an MDX query against a cube and get a set of results back. If
> the cube is then subsequently reprocessed with new data, and the same
> MDX query is re-run, the original results are returned in the XML, and
> not new results to reflect the reprocessed cube. It appears that this
> cache times out after a day, after which the latest results are
> returned in the XML/A query.
>
> The only solution that I can find to this is to stop IIS (the World
> Wide Web Publishing service) and restart it. Is there a better way to
> handle this, or turn off the caching?
>
> I am using Windows 2000 Server and Analysis Services SP2.
>
> Many thanks,
>
> Marcus

Relevant Pages

  • Re: Caching of Data in IIS / PTS
    ... > This may happen if you have set the Auto Synch Period on the connection ... > This property controls the frequency (in milliseconds) of client/server ... > query to the server. ... >> If I run an MDX query against a cube and get a set of results back. ...
    (microsoft.public.data.xmlanalysis)
  • Re: Caching of Data in IIS / PTS
    ... You should be able to experiment using MDX Sample -- connect, send a query, ... then process the cube and re-execute the query. ... Auto Synch Period option to see if it helps or not... ...
    (microsoft.public.data.xmlanalysis)
  • RE: Troubleshooting Execution Location
    ... It's much faster on the server. ... If I run the query once via HTTP, then I change the date range and run the query again, it's almost instantaneous the second time. ... have you made sure that each Distinct Count measure is in a cube ... the axis that I think would benefit the most from aggregation doesn't show up. ...
    (microsoft.public.sqlserver.olap)
  • Re: Timeout problems due to huge Fact Table
    ... I've also experienced very poor performing queries that the cube itself has ... of dimensions & with 'materialize' set on the relationships in the dimension ... to fill your cube you are using a very complex query instead of a table. ... level and adding required table in the database. ...
    (microsoft.public.sqlserver.olap)
  • Re: Risk Cube
    ... The 20 was produced by a query. ... This would have to change for each cell in your cube. ... I would like to create a cumulative Risk Cube. ... Exposure Value, Exposure Count ...
    (microsoft.public.access.forms)