AS uses a lot resources randomly

Last Post 03 Mar 2008 03:43 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 Jun 2007 02:42 PM
On SQL 2005 we randomly see CPU and disk IO usage from msmdsrv.exe (Analyses server). With no obvious reason during day time it may jump on 100% CPU (actualy single thread) and stay there several minutes. Any ideas?
New Member
New Member

03 Mar 2008 03:43 PM
What software is used to browse OLAP cubes?

Any cube report running?

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
BI Workshop NYC - March 17-20:

Acceptable Use Policy