AS hangs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

AS hangs

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.

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.


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |