Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Basic Usage

  1. Right-mouse on the Warehouse sample cube.
  2. Select Usage Analysis… from the context menu that appears, as shown in Figure 3.

    Figure 3: Select Usage Analysis … from the Context Menu

    The Welcome to the Usage Analysis Wizard dialog appears, as depicted in Figure 4.

    Figure 4: The Welcome to the Usage Analysis Dialog

    We see, within this dialog, the six pre-defined reports from which we can choose. Notice that clicking on any report title populates the Description field, beneath the selection list, with a short summary of the purpose of the report. The six reports and their descriptions are summarized in Table 1.

    Report Selection

    Description

    Query Run-Time Table

    The run time of queries, ordered from the longest to the shortest run time.

    Query Frequency Table

    The frequency of queries, ordered from the most to the least frequent.

    Active User Table

    Users and the number of queries they have enacted, ordered from the most to least queries sent per user.

    Query Response Graph

    A distribution of the response time for all queries.

    Query By Hour Graph

    The total number of queries processed, grouped together by hour.

    Query By Date Graph

    The total number of queries sent, grouped together by date.

    Table 1: The Six Preformatted, On-Screen Reports

    We will select the Query Frequency Table report for our initial walkthrough of the wizard.

    1. Select the Query Frequency Table report.
    2. Click Next.

    The Select the Criteria to Filter This Report dialog appears, as shown in Figure 5.

    Figure 5: The Select the Criteria to Filter This Report Dialog

    Continues…

Pages: 1 2 3 4 5




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |