Collecting metrics from an Azure service

Integrating Microsoft Azure with TrueSight Intelligence enables you to collect and display metrics from the following Azure services. Configuring TrueSight Intelligence to collect this data requires that you complete the following procedures. 

  • Virtual Machine
  • Elastic Pool
  • SQL
Related topic

Prerequisites

  • You must have access to the Global Admin role for performing these tasks. Request your admin for access. 
  • You must already have an application, or you can create an application key

To create an application key

If you do not have an application, complete the following procedure to the create an application key.

  1. Navigate to https://manage.windowsazure.com .
  2. Select Active Directory from the navigation pane and then click Default Directory from the list.
  3. Select the Applications tab and click Add
    1. Select Add an application my organization is developing
    2. Type a Name for the application, and select Web Application And/Or Web API
    3. Type https://truesight.bmc.com for the Sign-on URL, APP ID URI, and Reply URL.

To create credentials to access Azure

To create the credentials, you must get the client ID, client secret, and tenant ID. For more information, see the Azure documentation .

  1. Navigate to https://manage.windowsazure.com .
  2. Select Active Directory from the navigation pane.
  3. Click Default directory from the list.
  4. Click the Applications link, and select your application.
  5. From the Configure section, select Access Web APIs in other applications.
  6. Copy the ID from the Update your code with your client ID field to the clipboard.

    Tip

    Paste the client ID to a notepad file.

  7. From Create a key, click Configure key to generate a key used to access the Microsoft Azure Active Directory web APIs.
    1. Select the duration from the drop-down list
    2. The permissions to other applications section should have Windows Azure Active Directory.
      • From the Application Permissions menu, select:
        • Read and write devices
        • Read and write directory data
        • Read and write domains
        • Read directory data.
      • From the Delegated Permissions menu, select:
        • Read all users' basic profiles
        • Read all users' full profiles
        • Read all groups
        • Read and write all groups
        • Read and write directory data
        • Read directory data.
    3. Click Add application, and select Windows Azure Service Management API.
      • Ensure that no value is selected from the Application Permissions menu.
      • From the Delegated Permissions drop-down list, select Access Azure Service Management as organiza...
    4. Click Save to generate and display the value for the client secret.

      Warning

      Copy and paste the client secret to a notepad file. You will not be able to access the client secret after you leave the page.

  8. Click View endpoints to get a list of the App Endpoints.
  9. Copy the value from any of the fields to the clipboard. This is the endpoint used to obtain the tenant ID.

    Tip

    Paste the tenant ID in a notepad file. For example, if https://login.microsoftonline.com /random-setofcharacters-denoting-a-tenantID/oauth2/authorize is the value, you must copy and paste the highlighted section of the URL.

To add owners to the application

  1. Click https://manage.windowsazure.com .
  2. Navigate to Active Directory > Default Directory > Applications > Select the Application
  3. Click the Owners link from the top of the page.
  4. Click Add owners
  5. From the list, select the owners you want to add to the application

To associate the required roles for the application

  1. Navigate to https://portal.azure.com .
    Ensure that you enable diagnostics for virtual machines to collect metrics.  For more information, see https://blogs.technet.microsoft.com/canitpro/2016/05/31/step-by-step-enable-diagnostics-on-an-azure-virtual-machine .

  2. From the navigation pane, click Subscriptions
  3. From the Subscriptions page, double-click the Subscription ID or click Subscription Name.

    To monitor multiple subscriptions, repeat the following steps for each subscription.

  4. From the Settings pane, click Access control (IAM)
  5. Click Add, and select one role at a time:
    • Owner
    • Reader
    • Classic Storage Account Contributor
    • Storage Account Contributor
  6. Search the name of the application that you created for integrating with TrueSight Intelligence, and associate it to the selected role.
  7. Repeat Step 5 and 6 for each of the roles listed in Step 5.

To configure the integration

  1. Click settings > Data Collection > Azure and click Add to integrate and collect data from your Azure cloud instance.
  2. Use the Azure Configuration section to provide the details required to configure data collection from Azure:
    1. Type a Name for the Azure instance.
    2. Type a Description for your reference.
    3. Set the Polling Frequency (mins) used for polling the Azure instance.
    4. Type the Tenant Id for your Azure instance.
    5. Type the Client Id for your Azure user.
    6. Type the Client Secret for the Azure user.
      For more information on getting the values for the Tenant Id, Client Id and Client Secret, see To create credentials to access Azure, earlier in this topic.
    7. Select the TrueSight Intelligence App Name to which the Azure data will be associated or type the name for a new App.
  3. Click Validate and Continue to validate the details and open the Azure Services section to select the Azure services.

    Elastic PoolSQLVirtual Machine
  4. Click Continue to open the Azure Metrics section.

    Start adding filters for your table either in the macro settings or on the filtration pane.

    Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

    The table is being loaded. Please wait for a bit ...

    Metric Name 

    Service 

    Unit 

    Aggregation

    Azure EP Storage Limit

    Elastic Pool

    BYTECOUNT

    SUM

    Azure EP Storage Used

    Elastic Pool

    BYTECOUNT

    AVG

    Azure EP eDTU used

    Elastic Pool

    NUMBER

    AVG

    Azure EP eDTU limit

    Elastic Pool

    NUMBER

    AVG

    Azure EP Sessions percentage

    Elastic Pool

    PERCENT

    AVG

    Azure EP Workers percentage

    Elastic Pool

    PERCENT

    AVG

    Azure EP Total database size

    Elastic Pool

    PERCENT

    AVG

    Azure EP DTU percentage

    Elastic Pool

    PERCENT

    AVG

    Azure EP Log IO percentage

    Elastic Pool

    PERCENT

    AVG

    Azure EP Data IO percentage

    Elastic Pool

    PERCENT

    AVG

    Azure EP CPU percentage

    Elastic Pool

    PERCENT

    AVG

    Sessions percentage

    SQL

    PERCENT

    AVG

    Azure SQL Successful Conns

    SQL

    NUMBER

    SUM

    Azure SQL CPU percentage

    SQL

    PERCENT

    AVG

    Azure SQL Deadlocks

    SQL

    NUMBER

    SUM

    Azure SQL Database size percentage

    SQL

    PERCENT

    MAX

    Azure SQL DTU used

    SQL

    NUMBER

    AVG

    Azure SQL DTU limit

    SQL

    NUMBER

    AVG

    Azure SQL Failed Connections

    SQL

    NUMBER

    SUM

    Azure SQL Workers percentage

    SQL

    PERCENT

    AVG

    Azure SQL In-Memory OLTP storage percent(Preview)

    SQL

    PERCENT

    AVG

    Azure SQL Total database size

    SQL

    BYTECOUNT

    MAX

    Azure SQL DTU percentage

    SQL

    PERCENT

    AVG

    Azure SQL Log IO percentage

    SQL

    PERCENT

    AVG

    Azure SQL Data IO percentage

    SQL

    PERCENT

    AVG

    Azure SQL Blocked by Firewall

    SQL

    NUMBER

    SUM

    Azure Disk write time

    Virtual Machine

    DURATION

    AVG

    Azure Disk transfer time

    Virtual Machine

    DURATION

    AVG

    Azure Disk queue length

    Virtual Machine

    NUMBER

    AVG

    Azure Network out guest OS

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Network in guest OS

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Network Packets sent

    Virtual Machine

    NUMBER

    AVG

    Azure Packets received

    Virtual Machine

    NUMBER

    AVG

    Azure Network total bytes

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Network total bytes

    Virtual Machine

    NUMBER

    AVG

    Azure Packets sent errors

    Virtual Machine

    NUMBER

    AVG

    Azure Network collisions

    Virtual Machine

    NUMBER

    AVG

    Azure CPU percentage guest OS

    Virtual Machine

    PERCENT

    AVG

    Azure CPU interrupt time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU privileged time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU parking status

    Virtual Machine

    NUMBER

    AVG

    Azure CPU user time

    Virtual Machine

    PERCENT

    AVG

    Azure Processor percent perf.

    Virtual Machine

    NUMBER

    AVG

    Azure Processor frequency

    Virtual Machine

    NUMBER

    AVG

    Azure Threads

    Virtual Machine

    NUMBER

    AVG

    Azure Processes

    Virtual Machine

    NUMBER

    AVG

    Azure Context switches

    Virtual Machine

    NUMBER

    AVG

    Azure Memory committed

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Memory available bytes

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Memory commited bytes in use

    Virtual Machine

    PERCENT

    AVG

    Azure Cache faults

    Virtual Machine

    NUMBER

    AVG

    Azure Page faults

    Virtual Machine

    NUMBER

    AVG

    Azure Page reads

    Virtual Machine

    NUMBER

    AVG

    Azure Memory pages

    Virtual Machine

    NUMBER

    AVG

    Azure Transition faults

    Virtual Machine

    NUMBER

    AVG

    Azure Paged pool

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Non-paged pool

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Process total time

    Virtual Machine

    PERCENT

    AVG

    Azure Process page faults

    Virtual Machine

    NUMBER

    AVG

    Azure Process total threads

    Virtual Machine

    NUMBER

    AVG

    Azure Process total handles

    Virtual Machine

    NUMBER

    AVG

    Azure Process private bytes

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Process working set

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Process private working set

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Disk read guest OS

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Disk write guest OS

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Web service bytes

    Virtual Machine

    BYTECOUNT

    AVG

    Azure ISAPI extension requests

    Virtual Machine

    NUMBER

    AVG

    Azure Web connection attempts

    Virtual Machine

    NUMBER

    AVG

    Azure Web current connections

    Virtual Machine

    NUMBER

    AVG

    Azure Web get requests

    Virtual Machine

    NUMBER

    AVG

    Azure Web post requests

    Virtual Machine

    NUMBER

    AVG

    Azure Memory used

    Virtual Machine

    BYTECOUNT

    AVG

    Azure TCP connections failed

    Virtual Machine

    NUMBER

    AVG

    Azure TCP connections reset

    Virtual Machine

    NUMBER

    AVG

    Azure TCP segments sent

    Virtual Machine

    NUMBER

    AVG

    Azure TCP segments received

    Virtual Machine

    NUMBER

    AVG

    Azure TCP seg. restransmitted

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR time in jit

    Virtual Machine

    PERCENT

    AVG

    Azure .NET CLR time loading

    Virtual Machine

    PERCENT

    AVG

    Azure .NET CLR queue length

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR contention rate

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR logical threads

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR phys. threads

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR time in GC

    Virtual Machine

    PERCENT

    AVG

    Azure .NET CLR allocated

    Virtual Machine

    BYTECOUNT

    AVG

    Azure .NET CLR gen 0 heap size

    Virtual Machine

    BYTECOUNT

    AVG

    Azure .NET CLR gen 1 heap size

    Virtual Machine

    BYTECOUNT

    AVG

    Azure .NET CLR gen 2 heap size

    Virtual Machine

    BYTECOUNT

    AVG

    Azure .NET CLR large obj. heap size

    Virtual Machine

    BYTECOUNT

    AVG

    Azure .NET CLR heap bytes

    Virtual Machine

    BYTECOUNT

    AVG

    Azure .NET CLR connections

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR remote calls

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR exception rate

    Virtual Machine

    NUMBER

    AVG

    Azure .NET CLR interop marsh

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET running apps

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET wait time

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET req. queued

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET execution time

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET req. rejected

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET requests

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET errors

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET req. in app queues

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET pipeline instances

    Virtual Machine

    NUMBER

    AVG

    Azure ASP.NET req. executing

    Virtual Machine

    NUMBER

    AVG

    Azure SQL buffer page life

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL transaction rate

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL total data file KB

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL total log file used KB

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL user connections

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL total memory KB

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL batch request rate

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL attention rate

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL recompilation rate

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL error rate

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL active requests

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL blocked tasks

    Virtual Machine

    BYTECOUNT

    AVG

    Azure SQL CPU(Win) percentage

    Virtual Machine

    PERCENT

    AVG

    Azure SQL queued requests

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Mem. percent available

    Virtual Machine

    PERCENT

    AVG

    Azure Memory used percentage

    Virtual Machine

    PERCENT

    AVG

    Azure Mem. used by cache

    Virtual Machine

    PERCENT

    AVG

    Azure Memory Percent Pages

    Virtual Machine

    NUMBER

    AVG

    Azure Memory Page reads

    Virtual Machine

    NUMBER

    AVG

    Azure Memory Page writes

    Virtual Machine

    NUMBER

    AVG

    Azure Memory Swap available

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Mem Swap available %

    Virtual Machine

    PERCENT

    AVG

    Azure Memory Swap used

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Swap percent used

    Virtual Machine

    PERCENT

    AVG

    Azure CPU idle time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU user time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU nice time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU privileged time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU interrupt time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU DPC time

    Virtual Machine

    PERCENT

    AVG

    Azure CPU percentage guest OS

    Virtual Machine

    PERCENT

    AVG

    Azure CPU IO wait time

    Virtual Machine

    PERCENT

    AVG

    Azure Disk total bytes

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Disk read guest OS

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Disk write guest OS

    Virtual Machine

    BYTECOUNT

    AVG

    Azure Disk transfers

    Virtual Machine

    NUMBER

    AVG

    Azure Disk reads

    Virtual Machine

    NUMBER

    AVG

    Azure Disk writes

    Virtual Machine

    NUMBER

    AVG

    Azure Disk read time

    Virtual Machine

    DURATION

    AVG

    Azure TCP connections established

    Virtual Machine

    NUMBER

    AVG


    Alternately, click Start Over if you want to start over with the configuration.

  5. Select one or more metrics, or select all metrics to collect data. Use the search box to filter and display metrics that contain specific keywords.
  6. Click Save to save the integration.
    Alternately, click Start Over if you want to start over with the configuration.


Was this page helpful? Yes No Submitting... Thank you

Comments