AS hangs | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
AS hangsI have users running basic MDX reports against one of the production AS box and the server just hangs and never responds for like 20 minutes. I was wondering, if i have to check as to whats going on – where would i start? I.E, I am assuming since MDX are run against the cube and in the back ground the cube is getting the data from SQL server – shall i see at SQL Side to see whats going on or there’s another way to see, why my MDX are taking so long?
Appreciated if someone please share some thoughts.
First and best thing is to check the logs SQL error, event viewer and any other logs that can help you.
As you use cube for analysis , you must create other server for OLAP process.
it is not usual to let OLTP , OLAP in one box.