SQL Server Performance

Aggregation

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by Frederic, Feb 26, 2007.

  1. Frederic New Member

    Hello,<br /><br />I would like to know how sql server choose the aggregates to materialize in order to optimize the performances of database ?<br />Which tools are useful for that ?<br /><br /><br />Thanks for your help<br /><br />Fred<br /><br />ps: if you know some good websites about this topic, i am interested <img src='/community/emoticons/emotion-1.gif' alt=':)' />
  2. joechang New Member

    could you explain in more detail
    an example
  3. Frederic New Member

    Hello,

    Actually, i would like to know which tools does Sql Server 2005 have to propose choices about the aggregates to materialize in a datawarehouse.
    If it is possible, i would like to know how this tools works, if not, what exactly it can propose.

    Hopping i am more clear ...

    Thanks for you quick answer

    Fred
  4. joechang New Member

    i am not clear at all on what you are asking

    are you asking about Analysis Services?
    that the automatic aggregation

    the SQL Server relational database engine does not do automatic aggregation
    but you can explicitly create indexed views with aggregates
  5. Frederic New Member

    "the SQL Server relational database engine does not do automatic aggregation
    but you can explicitly create indexed views with aggregates"

    Is there a tool which can give advice in the choice of aggregates ?

Share This Page