Microsoft Windows and SQL Server infrastructure details reports
Summarize
Summary of Microsoft Windows and SQL Server Infrastructure Details Reports
The Microsoft Windows and SQL Server infrastructure details reports provide insights into SQL Server and Windows Server deployments across various cloud platforms, including Microsoft Azure, AWS, and GCP. This tool is essential for customers seeking to optimize their cloud infrastructure and understand their licensing costs effectively.
Show less
Key Features
- Azure BYOL Realized Savings Report: This report highlights potential and realized cost savings for SQL Server and Windows Server deployments on Azure using the Azure Hybrid Benefit (BYOL model).
- ServiceNow Integration: The report is accessible only through the ServiceNow® Cloud Cost Management application, which must be installed from the ServiceNow Store.
- Software Asset Workspace: Access the report via the Software Asset Workspace by navigating to Software Asset > Software Asset Workspace on your ServiceNow instance.
Key Outcomes
By utilizing the Azure BYOL Realized Savings report, ServiceNow customers can:
- Identify cost savings opportunities when leveraging the Azure Hybrid Benefit for their SQL Server and Windows Server instances.
- View detailed information about their Azure virtual machines, including host type, location, vCPU count, and hardware type.
- Understand both potential and actual monthly costs with and without the Azure Hybrid Benefit, enabling better financial planning and resource allocation.
You can use the Microsoft Windows and SQL Server infrastructure details reports to gain visibility into the SQL Server and Windows Server deployments and infrastructure for different cloud providers including Microsoft Azure, AWS, and GCP.
License types on cloud
Azure BYOL Realized Savings report
You can use the Azure BYOL Realized Savings report to gain visibility into the potential and actual cost savings for your Microsoft SQL Server and Microsoft Windows Server deployments on Microsoft Azure when using Azure Hybrid Benefit, which is the bring your own license (BYOL) licensing model for Microsoft Azure.
The Azure BYOL Realized Savings report is generated only if you have requested and installed the ServiceNow® Cloud Cost Management application from the ServiceNow Store. See Cloud Cost Management application for more information on Cloud Cost Management.
To view this report, launch the Software Asset Workspace by navigating to on your ServiceNow instance. From the Software Asset Workspace, navigate to .
| Field | Description |
|---|---|
| Virtual Machine | Azure virtual machine (VM) that Microsoft SQL Server or Microsoft Windows Server is running on. |
| Host Type | Type of Azure host that the Azure VM is running on. The options are Shared and Dedicated. |
| Location | Geographic location that the Azure host resides in. |
| vCPU | Number of virtual CPUs (vCPUs) that are assigned to the Azure VM. |
| Hardware Type | Hardware type of the Azure host. |
| Operating System | Operating system (OS) version and edition that is running on Azure. |
| SQL Server | Microsoft SQL Server version and edition that is running on the Azure VM. |
| AHB on Windows Server | Field indicating if Azure Hybrid Benefit is enabled for Microsoft Windows Server. |
| AHB on SQL Server | Field indicating if Azure Hybrid Benefit is enabled for Microsoft SQL Server. |
| Standard price per month without AHB | Potential VM cost per month when Azure Hybrid Benefit isn’t enabled. This value is based on the assumption that the VM is running for the entire month (720 hours). |
| Standard price per month with AHB | Potential VM cost per month when Azure Hybrid Benefit is enabled. This value is based on the assumption that the VM is running for the entire month (720 hours). |
| Standard Savings Realized | Potential VM cost saved per month by using Azure Hybrid Benefit. This value is based on the assumption that the VM is running for the entire month (720 hours). |
| Actual price per month without AHB | Actual VM cost per month when Azure Hybrid Benefit isn’t enabled. This value is based on the actual number of hours that the VM was running for within a month. |
| Actual price per month with AHB | Actual VM cost per month when Azure Hybrid Benefit is enabled. This value is based on the actual number of hours that the VM was running for within a month. |
| Actual Savings Realized | Actual VM cost saved per month by using Azure Hybrid Benefit. This value is based on the actual number of hours that the VM was running for within a month. |