SSAS – Cache Usage and Profiler

19 במרץ 2010

I recently was required to check on the performance of an SSAS instance. We had a new OLAP model with several MDX queries that we wanted to ensure were performing adequately. Now, you may know that SSAS is using caching in order to speed up its response time. Initial queries are directed to disk and once data is first read, it is then being placed in cache to serve future queries faster, eliminating the need to access disk again. What we did first was to clear the cache, using the following XMLA command: <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <ClearCache>...
תגובה אחת

Does “Not Supported” mean “Not Possible”? – SSAS 2008 upgrade plan…

8 במרץ 2010

I was reading through the (excellent) “SQL 2008 Upgrade Technical Reference Guide” paper from Microsoft the other day, which describes in great detail all the best practices of how to go about and upgrade your existing SQL Server 2000 and 2005 installations to SQL Server 2008. I was especially interested in the SSAS upgrade section, as I’m in the process of planning such an upgrade in a highly sensitive and data-intensive SSAS 2005 environment, so I wanted to be sure I was not overlooking anything important. Initially I was thinking of performing a side by side upgrade, where...
תגיות: , ,
אין תגובות