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
maris.orbidans
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?
SQLUSA
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: http://www.sqlusa.com/order2005bitr...008031720/



Acceptable Use Policy
---