User Profile
Scott_Kinghorn
MicrosoftJoined 6 years ago
User Widgets
Recent Discussions
Re: Virtual Machine Scale Set Metrics should have vCPU count
Hasnaa24 when you are looking at the CPU utilization, are you looking at the percentage cpu value across the entire scale set or are you looking at the utilization on a single node in the scale set? For a single node, we could look at making it easier to see the vCPU count property in Metrics explorer, but if you are looking at utilization across the entire scale set where the # nodes can vary due to scaling I can see why having the count in the metrics explorer view as an actual metric would be useful. I sent a note over to one of the folks I work with on the VMSS team to give them a heads up. If you are looking at the avg Percentage CPU across the entire VMSS then you may have a couple of ways to get close to what you are looking for. You could 'Apply Splitting' in metrics explorer by VMName to see the utilization per node, which would help address scaling but is a little tough to view when you have >10 nodes running. Another option would be to look at making a Workbook with 2 charts on it. One plotting the Maximum value for MetricName == 'ObservedCapacity' from the AzureMetrics table for the autoscale config you have on the VMSS, and the second chart the Percentage CPU across the VMSS. Not exactly what you are looking for, but would also help you see CPU trends vs scaling activities. Ping me if you need pointers on creating the workbook and I can send an example.Re: Virtual Machine Scale Set Metrics should have vCPU count
Hasnaa24 Currently the CPU count is shown as a property of the VMSS rather than as a metric. Where are you viewing the CPU utilization information? VMSS Overview - Monitoring tab, Metrics explorer, or in VMSS Insights? The VMSS Overview has CPU count on the Overview, and in VMSS Insights you can see the count of CPUs in a property panel. I don't know of a way to have cpu count appear in Metrics Explorer.Re: Azure Monitor Collection
tschary Here are a couple links that cover some options for exporting data from Log Analytics: export to storage or event hub and export with a logic app. Once you have the data in your new data store you can get that setup on Grafana. Would you mind sharing why you don't want to use Log Analytics and the Azure Monitor plugin for Grafana? KayodePrince and I would like to know if there is something about the experience we could improve.Re: Azure VM Insights Policy
miksingh that is the correct initiative, it has the policies needed to handle the onboarding. You can also take a look at this page for VMI that has details for the policy that can onboard your VMs. Another way to access the policies by navigating to Azure Monitor in the portal, then choose 'Virtual Machines' under the Insights section, and then the 'Other onboarding options' tab, which will have a tile that links you into the Policy view and pre-sets which policies to use - you just have to choose the correct scope and start assigning the policy.Re: Getting SQL query performance into log analytics
PatrikHansson I am working on the SQL monitoring preview you saw in the tweet. We are calling DMVs to get the sql monitoring data. Currently we don't return a lot of details on query perf stats in the preview version. Is there a DMV that you would like to use for this? For example, sys.dm_exec_query_stats.Re: VMInsights - Time Frequency
JK_UK Yes, the current method for monitoring a process is by setting up a performance counter on the workspace to send data into the Perf table. For example, you could use Process(*)\% Processor Time. As Noa mentioned, VMProcess is a metadata table used for Service Map an Azure Monitor for VMs. For more details, you can see the docs here.
