Hi - I've got a problem on our OLAP Server and though i'd ask here for anything obvious before i start poking about.
Every now and then any web sites that query OLAP cubes on this server fail to connect to the data - when i look on the server the process for Analysis Services (msdsvc - or something similar) is using over 1GB memory and the server is dead slow. i restart the OLAP service and everything is ok again - the process is only using 200mb memory now!!!
Anybody got any ideas what could be causing it - or an idea in which direction i should start poking around????
Don't know if thats enough info but i'll let anyone know more if they think they could help.