Azure Virtual Machine Insights

The 'Azure Virtual Machine Insights' workbook offers a comprehensive view of your Azure Virtual Machines (VMs) resources.

It enables you to delve into and compare key metrics effortlessly, gaining insights into usage trends, optimizing performance, and guiding strategic decisions effectively.

Overview

The Monitor dashboard provides a comprehensive view of all Virtual Machine (VM) metrics, enabling you to analyze their behavior and compare metrics across different VMs.

Monitor

CPU & Memory metrics

Network metrics

Disks metrics

Inventory

The Inventory dashboard offers a comprehensive overview of all Virtual Machine (VM) resources.

Introduction

Managing multiple VMs (Virtual Machines) requires effective management, performance comparison, and operational oversight — this functionalities facilitated by this workbook.

Structure and Views

Structure

This workbook contains 3 main parts:

• Overview - Holistic view of Azure Virtual Machines resources.
• Monitor - Holistic view of Azure Virtual Machines Metrics
• Inventory - Holistic view of Azure Virtual Machines Inventory.

Views

Types of views this workbook provides:

Overview

• Virtual Machines
  • Name
  • Resource Group
  • Location
  • Size
  • Operating system
  • Status
  • Time Created
  • OS Disk
  • Tags
  • Details

The information displayed uses KQL queries to query the Azure Resource Graph.

Monitor

• Overview
  • Percentage CPU (Avg)
  • Available Memory Bytes (Avg)
• Network
  • Network In Total (Sum)
  • Network Out Total (Sum)
• Disk
  • Overview
    • Disk Read Bytes (Sum)
    • Disk Write Bytes (Sum)
    • Disk Read Operations/Sec (Avg)
    • Disk Write Operations/Sec (Avg)
  • OS Disk
    • OS Disk Read Bytes/Sec (Avg)
    • OS Disk Write Bytes/Sec (Avg)
    • OS Disk Read Operations/Sec (Avg)
    • OS Disk Write Operations/Sec (Avg)
    • OS Disk Target Bandwidth (Avg)
    • OS Disk Target IOPS (Avg)
    • OS Disk Used Burst BPS Credits Percentage (Avg)
    • OS Disk Used Burst IO Credits Percentage (Avg)
    • OS Disk Latency (Preview) (Avg)
    • OS Disk Max Burst Bandwidth (Avg)
    • OS Disk Max Burst IOPS (Avg)
    • OS Disk Queue Depth (Avg)
    • OS Disk IOPS Consumed Percentage (Avg) **
    • OS Disk Bandwidth Consumed Percentage (Avg) **
    • Premium OS Disk Cache Read Hit (Avg) **
    • Premium OS Disk Cache Read Miss (Avg) **
  • Temp Disk
    • Temp Disk Read Bytes/Sec (Avg)
    • Temp Disk Write Bytes/Sec (Avg)
    • Temp Disk Read Operations/Sec (Avg)
    • Temp Disk Write Operations/Sec (Avg)
    • Temp Disk Latency (Preview) (Avg)
    • Temp Disk Queue Depth (Avg)
  • Data Disk
    • Data Disk Read Bytes/Sec (Avg)
    • Data Disk Write Bytes/Sec (Avg)
    • Data Disk Read Operations/Sec (Avg)
    • Data Disk Write Operations/Sec (Avg)
    • Data Disk Max Burst IOPS (Avg)
    • Data Disk Queue Depth (Avg)
    • Data Disk Used Burst IO Credits Percentage (Avg)
    • Data Disk Used Burst BPS Credits Percentage (Avg)
    • Data Disk Target IOPS (Avg)
    • Data Disk Target Bandwidth (Avg)
    • Data Disk Bandwidth Consumed Percentage (Avg)
    • Data Disk IOPS Consumed Percentage (Avg)
    • Data Disk Latency (Preview) (Avg)
    • Data Disk Max Burst Bandwidth (Avg)
• Flows
  • Inbound Flows (Avg)
  • Outbound Flows (Avg)
  • Inbound Flows Maximum Creation Rate (Avg)
  • Outbound Flows Maximum Creation Rate (Avg)
• VM Cached vs Uncached
  • VM Cached Used Burst IO Credits Percentage (Avg)
  • VM Uncached Used Burst IO Credits Percentage (Avg)
  • VM Cached Used Burst BPS Credits Percentage (Avg)
  • VM Uncached Used Burst BPS Credits Percentage (Avg)
  • VM Cached IOPS Consumed Percentage (Avg) **
  • VM Uncached IOPS Consumed Percentage (Avg) **
  • VM Cached Bandwidth Consumed Percentage (Avg) **
  • VM Uncached Bandwidth Consumed Percentage (Avg) **
• CPU Credits
  • CPU Credits Consumed (Avg) ***
  • CPU Credits Remaining (Avg) ***
• Other
  • VM Availability Metric (Preview) (Avg)

** Only available on VM series that support premium storage.

*** Only available on B-series burstable VMs.

Inventory

• Virtual Machines
  • Count by Subscription Id
  • Count by Resource Group
  • Count by Location
  • Count by VM Type
  • Count by Power State
  • Count by OS Type
  • Count by Operation System
  • Count by Publisher
  • Count by Offer
  • Count by HyperV Generation
  • Count by Hibernation Enabled

Filters

This workbook support to filter by:

• Subscription(s)
• Resource Group(s)
• Virtual Machine(s)
• Time range

How to use it?

Importing this Workbook to your Azure environment is quite simple.

Follow this steps to use the Workbook:

• Login to Azure Portal
• Go to 'Azure Workbooks'

• Click on '+ Create'

• Click on '+ New'

• Open the Advanced Editor using the '</>' button on the toolbar

• Select the 'Gallery Template' (step 1)

• Replace the JSON code with this JSON code Azure Virtual Machines Insights JSON (step 2)

  • We use the Gallery Templaty type (step 1), so we need to use the 'Azure Virtual Machines Insights.workbook' and not the 'Azure Virtual Machines Insights.json'.

• Click 'Apply' (step 3)

• Click in the ‘Save’ button on the toolbar

• Select a name and where to save the Workbook:
  • Title: 'Azure Virtual Machines Insights'
  • Subscription: <Subscription Name>
  • Resource group: <Resource Group Name>
  • Location: <Region>
• Click 'Save'

The Workbook is ready to use!

• Click on 'Workbooks'
• Click on 'Azure Virtual Machines Insights' Workbook.

Start using the Workbook and analyze your Azure Vierual Machines (VMs) resources.