I processed a cube and the query used by Analysis server
to retrieve fact data some causes. The source SQL Server
to call the system stored procedure CacheRemove which
clears cache of almost all other cached SQL codes. This
in turn increases the size of tempdb infinitely. SQL
Server error logs do report Buf Latch Failure. But
solution recommends service pack 3 which I already have.