No announcements
Found 2394988 threads
-
0 VotesHow do you troubleshoot a slow running query?
They asked me, if one of your users came to you and told you that a query that use to run 2 seconds, now takes a few minutes to run, how would you go about ...Answered | 9 Replies | 12054 Views | Created by Diango - Thursday, September 19, 2013 2:00 PM | Last reply by Manu_vmr - Sunday, September 22, 2013 7:01 PM
-
0 Votes
MDX query exponential performance degredation
displaylang=en&id=17303 It is also good to execute MDX using MDX studio and understand the SE Queries and SubCubes for any ...Answered | 2 Replies | 1506 Views | Created by Lee Cascio - Wednesday, August 21, 2013 2:41 PM | Last reply by Prav_SQL - Wednesday, August 21, 2013 10:32 PM -
0 Votes
MDX Query performance slower on multi-core server?
The conclusion I came to is that it's nearly impossible to accurately compare the performance of CPUs just by looking at the GHz number advertised.Answered | 2 Replies | 6470 Views | Created by SteveBI - Tuesday, June 30, 2009 2:58 PM | Last reply by - Thursday, February 4, 2016 2:47 AM -
0 Votes
MDX query performance
The performance issue is merely because you are having a cross join over three dimension and if they are large you are doing enourmous number of cell evaluation.Answered | 1 Replies | 4704 Views | Created by kirank_gh - Monday, July 27, 2009 5:12 PM | Last reply by Ashwani Roy - Monday, July 27, 2009 5:39 PM -
0 Votes
MDX query performance issue
I have made small change in the mdx to overcome performance issue with the below query and need your input.Answered | 10 Replies | 2036 Views | Created by Abdul527 - Monday, June 6, 2016 6:23 PM | Last reply by Christopher Webb - Tuesday, June 14, 2016 8:40 PM -
0 Votes
MDX Performance
The other thing is a query runs fast in SSMS but the same query in a report with parameters becomes slow.Answered | 2 Replies | 4816 Views | Created by Erdem Zengin - Monday, December 20, 2010 3:51 PM | Last reply by Erdem Zengin - Wednesday, December 22, 2010 8:14 AM -
0 Votes
Performance Of MDX Queries
Hi Vijay, Its bit difficult to tell exact How to improve MDX Queries without having any idea.Answered | 2 Replies | 3106 Views | Created by Munna Kollu - Wednesday, September 28, 2011 9:07 PM | Last reply by Suhas Kudekar - Thursday, September 29, 2011 5:21 AM -
1 Votes
Slow MDX query
http://msdn.microsoft.com/en-us/library/ms144936.aspx How many members each set contains ?Answered | 5 Replies | 2169 Views | Created by Sam1980 - Sunday, May 26, 2013 3:00 AM | Last reply by anant_gupta - Monday, May 27, 2013 12:24 PM -
1 Votes
MDX Query performance issues - NonEmptyCrossJoin, Multiple nested IIFs and FILTER
In addition to what Stacia has mentioned, you can also refer this ...Answered | 2 Replies | 8239 Views | Created by Deepak.P - Wednesday, February 16, 2011 6:36 AM | Last reply by Vinuthan - Monday, April 4, 2011 11:02 PM -
2 Votes
MDX Performance Issue - Dimension Member Count(Filter())
It's pretty slow!Answered | 13 Replies | 6343 Views | Created by Ken in Tampa - Wednesday, August 14, 2013 8:05 PM | Last reply by Prav_SQL - Tuesday, October 22, 2013 9:49 PM -
0 Votes
MDX Query performance tips needed here
I did not understood below point.Answered | 8 Replies | 760 Views | Created by Aniruddha Thengadi - Sunday, March 4, 2018 11:04 AM | Last reply by Ju_Fad - Tuesday, March 6, 2018 12:59 PM -
0 Votes
How to do conditional selection of MDX queries
Hi Gaurav Gupta, I know that your poste is very old, but I have a question in relation to your answer.Answered | 4 Replies | 4221 Views | Created by Vikram383 - Wednesday, July 10, 2013 12:03 PM | Last reply by AHleonIT - Wednesday, March 1, 2017 1:51 PM -
0 Votes
Total Cells in MDX Query
I wanted to model response time for MDX query using lets say 100 or 200 mdx queries that i have.Answered | 6 Replies | 7205 Views | Created by O_P - Monday, May 10, 2010 7:34 PM | Last reply by castlooo - Friday, April 8, 2011 7:44 AM -
0 Votes
Duration MDX query
id=661 If you would like help troubleshooting the performance of this query, then post all the calculations that come into play.Answered | 9 Replies | 3926 Views | Created by erde - Thursday, April 26, 2012 10:27 AM | Last reply by GregGalloway - Saturday, May 5, 2012 7:36 PM -
1 Votes
Power Query MDX Issues
I feel like the design is pretty effective, but I have issues with how Power Query implements the filtering.Answered | 1 Replies | 1066 Views | Created by ScottT003 - Tuesday, February 21, 2017 3:54 PM | Last reply by Imke Feldmann - Wednesday, February 22, 2017 8:40 AM -
0 Votes
SSRS - Query performance slow because of parameter
When you run the parameterized report, the performance is very slow, right?Answered | 8 Replies | 4819 Views | Created by RitikaSingh0211 - Thursday, March 5, 2015 3:09 PM | Last reply by Qiuyun Yu - Sunday, March 8, 2015 5:25 AM -
0 Votes
Query Performance Issue
Now I have to wait until next UAT Release to compare the performance.Answered | 7 Replies | 3270 Views | Created by tschi2001 - Wednesday, August 31, 2011 9:07 AM | Last reply by tschi2001 - Thursday, September 1, 2011 6:30 AM -
0 Votes
Performance Issue with slow running query
Hi BGop, There are a number of common reasons for slow-running queries and updates.Answered | 6 Replies | 1597 Views | Created by BGop - Tuesday, December 17, 2013 3:12 PM | Last reply by Heidi-Duan - Thursday, December 26, 2013 8:34 AM -
7 Votes
How do I write Parameter using MDX query?
Actually I am Doing Line Chart.Answered | 10 Replies | 22420 Views | Created by Sam_1016 - Thursday, January 5, 2012 2:31 PM | Last reply by Challen Fu - Tuesday, January 10, 2012 9:08 AM -
0 Votes
MDX query taking a long time
I am programmaticly generating a MDX query in the following format: WITH MEMBER [Measures].Answered | 3 Replies | 4552 Views | Created by squarewave24 - Monday, December 5, 2011 10:17 PM | Last reply by rok1 - Tuesday, December 6, 2011 3:55 PM - Items 1 to 20 of 2394988 Next ›
No announcements
