|
|
||||||
|
#1
09-10-07, 08:30 PM
|
|
|
|
|
Hello, every time I process the cubes, the cache gets deleted. Our server is
also very limited on RAM (4GB). Is there a way to prevent the cache from getting deleted? When users query the cube via Pivot Table in Excel, the response time is much slower if there isn't a warm cache. Also, can someone please tell me how to go about creating a warm cache? Do I need to Open Excel and manually refresh the pivot table after every full process, or is there some way to automate warm cache creation? I added a button in Excel and attached some VB code to refresh all the pivot tables at once in the workbook, but this is still a manual process that I would like to avoid if possible. Thanks for your help! Jason McGuire [url down] |
|
|
|
#2
09-10-07, 11:53 PM
|
|
|
|
|
do you use SSAS 2005 or 2000?
with 2005 you can execute some queries using the ASCMD command line utility you have to write some MDX queries to warm your cache based on your common usage. generally we run these queries just after a process of the cubes. "Jason" <jason2004> wrote in message news:6190 [..] |
|
#3
09-11-07, 12:42 AM
|
|
|
|
|
Thanks Jeje! I'm using SSAS 2005 and SQL Server 2005.
Can you please send me a link or an example of how to warm the cache using MDX? I appreciate your help. Jason "Jeje" wrote: [..] |
|
#4
09-11-07, 01:12 AM
|
|
|
|
|
take a look at this:
http://msdn.microsoft.com/en-us/library/ms365187.aspx specially the scemario 5. "Jason" <jason2004> wrote in message news:24ca [..] |
|
#5
09-11-07, 04:34 AM
|
|
|
|
|
Thanks Jeje!
"Jeje" wrote: [..] |
|
|
| Similar Threads | |
| Macro to clear the MS Office Project 2007 Cache We all know how wonderful the NEW cache functionality is on Microsoft Office Project 2007 Professional. The problem for me as an EPM administrator is that some PM's cache... |
|
| Cold cache and warm cache, what's it? I am reading some pieces of Linux kernel code and find some concepts about cold cache and warm cache, they are new to me, google didn't help me much, so what are they? Can... |
|
| Using 70-306 as warm-up for 70-316 Is it permitted to take 306 (VB.NET apps) one week, and then take 316 (C# apps) the following week? (irrespective of whether you pass exam 306) Secondly, can you choose... |
|
| Error 5063: database .. is in warm standby. A warm-standby is read only. A freshly restored DB is readonly(I choose "readonly" ,when restore it). The restore was successful ,but when try to change it to readwrite . Error 5063 poped up. I found on... |
|
| Warm or something else? Hy When I tried to search for a web page, my Internet explorer cut down. It still happens when i try to search for something, except for a few pages. I thought it's Mydoom... |
|
|
All times are GMT. The time now is 03:35 AM. | Privacy Policy
|
Warm Cache - VB - Macro