SQL Server Performance

AS hangs

Discussion in 'SQL Server 2005 Analysis Services' started by california6, Jun 26, 2008.

  1. california6 New Member

    I 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.
  2. satya Moderator

    First and best thing is to check the logs SQL error, event viewer and any other logs that can help you.
  3. moh_hassan20 New Member

    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.

Share This Page