April 12, 2010 at 8:19 am
I have set up a cube partition to "update the cache when data changes" and have enabled proactive caching, yet cube stops refreshing after 1-2 hrs.
Here are the settings:
- Storage mode: MOLAP
- Enable proactive caching
- Update the cache when data changes
- Silence interval : 10 sec
- Silence Override interval: 5 minutes
Anyone know what the issue might be and/or how I can troubleshoot this?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 19, 2010 at 2:54 pm
Not sure I can help. But to be clear, the cube refreshes properly for a while (1 to 2 hours) and then mysteriously stops refreshing. Is this correct?
April 20, 2010 at 11:00 am
That's correct, I have opened a case with MS on this issue, still no resolution.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 20, 2013 at 11:49 am
Exact same problem using SQL 2008 R2.
Cubes update with notifications being sent to AS but then randomly it all stops!
Did you get a solution?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply