Version 3

    This template contains performance & statistics counters for monitoring Sql Server Database.


    Prerequisites:

    1. PowerShell module (Azure, AzureRM) has to be installed prior to run this template on target machine.
    2. To connect with Azure account following parameter are required: subcriptionID, ApplicationID, TenantID, Secret Key, Database Name

    Note: Any Azure App (with its name & ID) having minimum role as 'Read Only'.

        3. SQL Server Database Name for which metrics has to be calculated.

        4. Time interval for which data has to be fetched (in hours).

        5. PowerShell version 5.0 or later.

     

     

    Credentials:

    1. Login credential to access Azure Portal. This has to be passed as script arguments per prerequisites 2 above. e.g. <subscriptionID>, <TenantID>, <ApplicationID>, value=<Secret Key>, <SQL Server Database Name>, value=<Time Interval>

    Windows Administrator on the machine where template would be running against.     

     

    Portions of this document were originally created by and are excerpted from the following sources:

     

    https://azure.microsoft.com/en-in/blog/windows-azure-sql-database-management-with-powershell/

    https://docs.microsoft.com/en-us/azure/monitoring-and-diagnostics/monitoring-supported-metrics

     

     

    Notes:

    • To install Azure module, execute below PowerShell commands on the machine where template would be running against.

    Install-Module -Name Azure

    Install-Module -Name AzureRM

    • The ApplicationID with which you are making a connection to Azure portal (as mentioned in Credential/Prerequisites) must be registered in Azure Active Directory as read only/contributor role for the monitored application.

    Reference link: https://support.solarwinds.com/Success_Center/Server_Application_Monitor_(SAM)/Knowledgebase_Articles/Add_an_Azure_Active_Directory_app_for_cloud_monitoring_in_the_Orion_Platform

     


    MONITORED COMPONENTS

    Blocked Connections

    This metric provides the average number of firewall blocked connections established for the given SQL database during the time period specified as the Polling Frequency.

    Unit: Count

    Failed Connections

    This monitor provides the average number of failed connections established for the given SQL database during the time period specified as the Polling Frequency.

    Unit: Count

    Successful Connections

    This metric provides the average number of successful connections established for the given SQL database during the time period specified as the Polling Frequency.

    Unit: Count

    Deadlocks

    This metric provides the average number of deadlocks established for the given SQL database during the time period specified as the Polling Frequency.

    Unit: Count

    Database throughput units (DTU) Limit

    This metric provides the average database throughput limit in units for the given SQL database during the time period specified as the Polling Frequency.

    Unit: Count

    Database throughput units (DTU) used

    This metric provides the average database throughput units used for the given SQL database during the time period specified as the polling frequency.

    Unit: Count

    Sessions percentage

    This metric provides the average percentage of available sessions used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    Database size percentage

    This metric provides the average percentage of storage used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    Total database size

    This metric provides the average for the total database size for the given SQL database during the time period specified as the polling frequency.

    Unit: Bytes

    Workers percentage

    This metric provides the average percentage of available workers used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    Average CPU utilization

    This metric provides the average percent CPU used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    Average IO utilization

    This metric provides the average percentage of data IO used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    Average log utilization

    This metric provides the average percentage of log IO used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    In-Memory OLTP storage percent

    This monitor provides the average In-Memory OLTP (Online Transaction Processing) storage percent for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent

    Database throughput unit (DTU) percentage

    This metric provides the average percentage of database throughput units used for the given SQL database during the time period specified as the polling frequency.

    Unit: Percent