Skip to Content
avatar image
Former Member

Problems in creating the report to find top 5 long running Queries

Hi,

I am trying to create a report which should give the result for top 5 long runnings queries for the givin multiprovider or all the multi providers.

I am creating the report on 0TCT_MC01 statistics cube. But it is displaying the result for all queries with all executed times. But i want only top 5. If i include the condition to put top 5, same query is getting if it takes long time.

how can i achieve this.

Regards,

Vishnu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 26, 2008 at 07:29 AM

    it will take a long time - so you then tune your stats cubes - do exactly the same thing if one of your normal queries was taking a long time

    Have you compressed your stats cubes? are the DB statistics up to date?

    Are they partitioned? Have you put a selection on a date parameter using the partioned time characteristic

    etc..

    etc..

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Well conditions work on the entire result set - and if the result set is large - then unfortunately unless you tune memory then that is how long it is going to take

  • avatar image
    Former Member
    Oct 23, 2008 at 07:19 AM

    thnx

    Add comment
    10|10000 characters needed characters exceeded