Replied 3 August 2017, 4:01 pm EST
Thank you for your observations I have passed the same to our dev team as well. However we would need to replciate the issue at our end to find a solution the issue that you have reported. In order to replicate the issue I have tried querying a table(which has 7,00,000 rows and 15 columns) with simple select statement to fetch all all records and columns from the database. This query executes for about 2 minutes on the SQL Server . I have however not succeeded in replicating the behavior. The SQL Server 2008 R2 is hosted on a Windows Server 2008 R2 machine at my end.
Could you please provide some additional information regarding the following so that we may try creating a similar environment at our end to replicate the issue at our end.
1. The version of SQL Server and Operating the System that you are using .
2. The number of rows and columns in your database and also the datatype of columns.
3.The SQL query that you have used to query the database and the number of records, columns that are been fetched.
4.The build number of ActiveAnalysis that you are using.
However ,It would have been very helpful if you could send us your .bak file of the database and the schema so that we could recreate the same environment at our end. Please feel free to provide any additional details that may help us replicate the issue at our end.