SQL Server Performance

Usage Based Optimization - problem

Discussion in 'SQL Server 2005 Analysis Services' started by nadlerb2, Jan 2, 2007.

  1. nadlerb2 New Member

    Hi everyone

    I'm trying to set my aggregations through the usage based optimization tool

    on sql server 2000

    I have about 25 users active using my viewer (panorama) and when i'm trying to filter my data on the first step of the Usage Based Optimization wizard i get no result

    can anybody tell my howcome no statistics is shown??????????

    thanks.........
  2. satya Moderator

    Any error or warning during this behaviour?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. ranjitjain New Member

  4. nadlerb2 New Member

    i just get empty results, as if no queries were logged
  5. ranjitjain New Member

    Have you enabled the query logging for analysis server?
  6. nadlerb2 New Member

    Do u mean checking the "log queries sent to server" checkbox in the analysis server properties under the logging tab, bcz its checked
  7. ranjitjain New Member

    yes, i just wanted to confirm that.
    Anyways, can you also confirm whether the cube on which you are running usage based optimisation is processed or not by browsing data.
    If it is not processed then optimisation will not work.
    Also which option have you selected in usage based screen to filter the queries.
  8. nadlerb2 New Member

    the cube is processed and i picked queries that took longer than 0 seconds without restricting the users so i should get a lot of results
  9. ranjitjain New Member

    Well i dont see anything wrong so far.
    Try selecting the option of queries executed more than 0 times.
    also i assume you must have restarted the AS service after enabling the option of Logging Queries sent to server.

Share This Page