CPU, Memory and Hard Drive Baseline Specs

%3CLINGO-SUB%20id%3D%22lingo-sub-549677%22%20slang%3D%22en-US%22%3ECPU%2C%20Memory%20and%20Hard%20Drive%20Baseline%20Specs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-549677%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBackground%3A%20We%20have%20more%20than%20terabytes%20of%20data%20we've%20collected%20over%20the%20last%20week.%20We've%20stopped%20the%20collection%20this%20week.%20And%20we%20now%20have%20%3CSTRONG%3E30%20days%3C%2FSTRONG%3E%20to%20either%20pull%20the%20data%20and%20put%20it%20somewhere%20(I'm%20not%20sure%20if%20that's%20even%20possible%20in%20LogAnalytics)%2C%20or%20we%20query%20and%20get%20as%20much%20information%20as%20possible.%3CBR%20%2F%3EWe%20are%20building%20out%20a%20new%20VM%20environment%2C%20but%20the%20specs%20are%20still%20unknown.%20We%20would%20like%20to%20use%20the%20data%20we've%20collected%20to%20the%20baseline%20specs.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESo%20how%20much%20will%20each%20VM%20processor%20speeds%2Fcore%2C%20memory%2C%20and%20hard%20drive%20space.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EAnd%20as%20a%20bonus%2C%20what%20process%20they%20are%20running%20that%20are%20being%20used%20(im%20not%20sure%20if%20the%20performance%20data%20will%20get%20this.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-549677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Retention%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-551988%22%20slang%3D%22en-US%22%3ERe%3A%20CPU%2C%20Memory%20and%20Hard%20Drive%20Baseline%20Specs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-551988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F278666%22%20target%3D%22_blank%22%3E%40rockypabillore%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%2C%20what%20Data%20Tables%20do%20you%20have%2C%20that%20is%20more%20important%20than%20your%20capacity%20of%20Logs%20at%20this%20stage%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20assuming%20you%20have%20the%20%3CSTRONG%3EPerf%3C%2FSTRONG%3E%20table%3F%26nbsp%3B%20If%20so%20what%20Perf%20%3CSTRONG%3Ecounters%3C%2FSTRONG%3E%20are%20you%20collecting%3F%26nbsp%3B%20%26nbsp%3BThis%20will%20show%20the%20tables%20in%20use%2C%20can%20you%20share%20the%20results%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3Esearch%20*%0A%7C%20summarize%20count()%20by%20%24table%0A%7C%20sort%20by%20count_%20desc%20%20%3C%2FPRE%3E%0A%3CP%3EThis%20will%20all%20list%20any%20counters%20you%20have%20collected%3A%3C%2FP%3E%0A%3CPRE%3EPerf%0A%7C%20summarize%20count()%20by%20CounterName%0A%7C%20sort%20by%20count_%20desc%20%20%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20do%20have%20Perf%2C%20and%20this%20specific%20counter%20then%20you%20can%20get%20cores%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%2F%2F%20count%20cores%20on%20each%20computer%2C%20exclude%20_total%20with%20regex%0APerf%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%0A%7C%20where%20InstanceName%20matches%20regex%20%40'%5B0-9%5D'%0A%7C%20summarize%20Cores%20%3D%20dcount(InstanceName)%2C%20CoreList%20%3D%20make_set(InstanceName)%20by%20%20Computer%3C%2FPRE%3E%0A%3CP%3EIf%20you%20have%20this%20table%2C%20then%20you%20could%20get%20cores%2C%20speed%20and%20memory%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3EServiceMapComputer_CL%0A%7C%20distinct%20Computer%2C%20Cpus_d%2C%20CpuSpeed_d%2C%20PhysicalMemory_d%0A%7C%20summarize%20cores%20%3D%20sum(Cpus_d)%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20CpuSpeed%20%3D%20sum(CpuSpeed_d)%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20PhysicalMemeory%20%3D%20sum(PhysicalMemory_d)%20%0A%20%20by%20Computer%20%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDisk%20space%20needs%20two%20Perf%20counters%20(if%20you%20want%20the%20in-use%20and%20disk%20capacity)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3Elet%20myPCT%20%3D100%3B%20%20%2F%2F%20show%20all%20drives%20%3D%20100%20or%20show%20only%20drives%20below%20%3D%20nn%20%25%0APerf%0A%7C%20where%20CounterName%20%3D%3D%20%22Free%20Megabytes%22%0A%7C%20where%20TimeGenerated%20%26gt%3B%20startofday(ago(1d))%0A%7C%20where%20InstanceName%20has%20%22%3A%22%20and%20strlen(InstanceName)%20%3D%3D2%0A%2F%2F%20only%20look%20at%20drive%20letters%0A%7C%20summarize%20MbFree%3Davg(CounterValue)%20by%20Computer%2CInstanceName%2Cbin(TimeGenerated%2C%205m)%0A%7C%20summarize%20arg_max(TimeGenerated%2C%20*)%20by%20Computer%2CInstanceName%0A%7Cjoin%20kind%3D%20inner%0A(%0A%20%20%20%20Perf%0A%20%20%20%20%7C%20where%20CounterName%20%3D%3D%20%22%25%20Free%20Space%22%0A%20%20%20%20%7C%20where%20TimeGenerated%20%26gt%3B%20startofday(ago(1d))%0A%20%20%20%20%7C%20where%20InstanceName%20has%20%22%3A%22%20and%20strlen(InstanceName)%20%3D%3D2%0A%20%20%20%20%2F%2F%20only%20look%20at%20drive%20letters%0A%7C%20summarize%20PctFree%3Davg(CounterValue)%20by%20Computer%2CInstanceName%2Cbin(TimeGenerated%2C%205m)%0A%7C%20summarize%20arg_max(TimeGenerated%2C%20*)%20by%20Computer%2CInstanceName%0A)%0Aon%20Computer%20%2C%20InstanceName%0A%7C%20project%20%20%20TotalSizeGB%3Dround(MbFree*100%2FPctFree%2F1024%2C0)%2Cround(PctFree%2C2)%2Cround(MbFree%2C2)%2CComputer%2CInstanceName%0A%7C%20where%20PctFree%20%26lt%3B%3D%20myPCT%0A%2F%2F%20only%20shows%20drives%20with%20space%20below%20this%20value%0A%7C%20summarize%20FreePCT%3Davg(PctFree)%20by%20Computer%2CDriveLetter%20%3D%20InstanceName%2CTotalSizeGB%2CFreeGB%20%3D%20round(MbFree%20%2F%201024%2C2)%0A%7C%20sort%20by%20DriveLetter%20%20asc%3C%2FPRE%3E%0A%3CDIV%20class%3D%22k-grid-header%22%3E%0A%3CDIV%20class%3D%22k-grid-header-wrap%20k-auto-scrollable%22%20data-role%3D%22resizable%22%3E%0A%3CDIV%20class%3D%22k-resize-handle%22%3E%0A%3CDIV%20class%3D%22k-resize-handle-inner%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20class%3D%22k-resize-handle-inner%22%3EExample%20output%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3CDIV%20class%3D%22k-grid-content%20k-auto-scrollable%22%3E%0A%3CTABLE%20tabindex%3D%220%22%20role%3D%22treegrid%22%20aria-activedescendant%3D%22queryResultsViewGrid_active_cell%22%3E%3CCOLGROUP%3E%3CCOL%20class%3D%22k-hierarchy-col%22%20%2F%3E%3CCOL%20%2F%3E%3CCOL%20%2F%3E%3CCOL%20%2F%3E%3CCOL%20%2F%3E%3CCOL%20%2F%3E%3CCOL%20%2F%3E%3C%2FCOLGROUP%3E%0A%3CTBODY%20role%3D%22rowgroup%22%3E%0A%3CTR%3E%0A%3CTD%3E%26nbsp%3B%3C%2FTD%3E%0A%3CTD%3E%3CA%20class%3D%22k-link%22%20tabindex%3D%22-1%22%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FScripts%2Fprod%2F%23%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EComputer%3C%2FA%3E%3C%2FTD%3E%0A%3CTD%3E%3CA%20class%3D%22k-link%22%20tabindex%3D%22-1%22%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FScripts%2Fprod%2F%23%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EDriveLetter%3C%2FA%3E%3C%2FTD%3E%0A%3CTD%3E%3CA%20class%3D%22k-link%22%20tabindex%3D%22-1%22%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FScripts%2Fprod%2F%23%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ETotalSizeGB%3C%2FA%3E%3C%2FTD%3E%0A%3CTD%3E%3CA%20class%3D%22k-link%22%20tabindex%3D%22-1%22%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FScripts%2Fprod%2F%23%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFreeGB%3C%2FA%3E%3C%2FTD%3E%0A%3CTD%3E%3CA%20class%3D%22k-link%22%20tabindex%3D%22-1%22%20href%3D%22https%3A%2F%2Fportal.loganalytics.io%2FScripts%2Fprod%2F%23%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EFreePCT%3C%2FA%3E%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3CTR%20class%3D%22k-master-row%22%20role%3D%22row%22%20data-uid%3D%22781da99d-59e8-4e17-adbc-d3cbc543ebcc%22%3E%0A%3CTD%20class%3D%22k-hierarchy-cell%22%20aria-expanded%3D%22false%22%3E%26nbsp%3B%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%20aria-describedby%3D%226732dec2-3939-4bf1-9a22-28f7b0fa900c%22%3EDC02%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%20aria-describedby%3D%225840bfa8-cbc9-451b-9f2f-fa6cc331e195%22%3EC%3A%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%20aria-describedby%3D%221411428c-f26d-468a-b090-4882a47e7033%22%3E40%3C%2FTD%3E%0A%3CTD%20class%3D%22%22%20aria-describedby%3D%223eadc5c5-c8b7-417d-9875-e6e28274b94f%22%3E18.44%3C%2FTD%3E%0A%3CTD%20class%3D%22k-state-focused%22%20aria-describedby%3D%22a7e84c42-254c-4f01-9d36-cd4b6027d894%22%3E46.1%3C%2FTD%3E%0A%3C%2FTR%3E%0A%3C%2FTBODY%3E%0A%3C%2FTABLE%3E%0A%3C%2FDIV%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20had%20%3CSTRONG%3EVMconnection%3C%2FSTRONG%3E%20then%20this%20would%20work%20to%20look%20at%20Processes%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%2F%2F%20show%20bytes%20per%20process%20by%20Computer%0AVMConnection%0A%7C%20summarize%20count(BytesSent)%2C%20count(BytesReceived)%2C%20make_set(ProcessName)%20%20by%20%20Computer%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-552847%22%20slang%3D%22en-US%22%3ERe%3A%20CPU%2C%20Memory%20and%20Hard%20Drive%20Baseline%20Specs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3EThanks%20for%20the%20suggestions!%20here's%20the%20list%20that%20I've%20been%20pulling%3A%20%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20298px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112750iCA9A26CC387C4618%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20260px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112751iF663D12697500055%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20run%20the%20Core%20Counts%20its%20giving%20me%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20762px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112752i6B13A3AC5A443BA0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20right%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20also%20getting%20no%20results%20for%20the%20hard%20drive%20space%20query%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20755px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112753i5F479B7BEDB8F3AD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-553185%22%20slang%3D%22en-US%22%3ERe%3A%20CPU%2C%20Memory%20and%20Hard%20Drive%20Baseline%20Specs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553185%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F278666%22%20target%3D%22_blank%22%3E%40rockypabillore%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHe%20is%20an%20updated%20cores%20query%2C%20that%20should%20work%20better%3F%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%2F%2F%20count%20cores%20on%20each%20computer%2C%20exclude%20_total%20with%20regex%0APerf%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%20%20and%20ObjectName%20%3D%3D%20%22Processor%22%0A%7C%20where%20InstanceName%20matches%20regex%20'%5B0-9%5D'%0A%7C%20summarize%20Cores%20%3D%20dcount(InstanceName)%2C%20CoreList%20%3D%20make_set(InstanceName)%20by%20%20Computer%3C%2FPRE%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CPRE%3EPerf%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%20and%20ObjectName%20%3D%3D%20%22Processor%22%0A%7C%20where%20InstanceName%20matches%20regex%20%40'%5B0-9%5D'%0A%7C%20summarize%20Cores%20%3D%20dcount(InstanceName)%20by%20%20Computer%0A%7C%20sort%20by%20Cores%20desc%20%0A%7C%20render%20barchart%20%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20doesn't%20look%20like%20you%20have%20%22free%20megabytes%22%20counter%2C%20so%20the%20query%20just%20needs%20to%20be%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3Elet%20myPCT%20%3D%20100%3B%0APerf%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Free%20Space%22%0A%7C%20where%20TimeGenerated%20%26gt%3B%20startofday(ago(1d))%0A%7C%20where%20InstanceName%20has%20%22%3A%22%20and%20strlen(InstanceName)%20%3D%3D2%0A%2F%2F%20only%20look%20at%20drive%20letters%0A%7C%20summarize%20PctFree%3Dround(avg(CounterValue)%2C2)%20by%20Computer%2CInstanceName%0A%7C%20where%20PctFree%20%26lt%3B%3D%20myPCT%0A%7C%20sort%20by%20PctFree%20%20desc%20%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1505572%22%20slang%3D%22en-US%22%3ERe%3A%20CPU%2C%20Memory%20and%20Hard%20Drive%20Baseline%20Specs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505572%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239477%22%20target%3D%22_blank%22%3E%40Clive%20Watson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewith%20the%20help%20of%20below%20query%20can%20I%20get%20the%20Cores%20Utilization.%3F%3C%2FP%3E%3CP%3EI%20was%20refering%20to%20the%20Article%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fmetrics-supported%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Fplatform%2Fmetrics-supported%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20I%20couldn't%20make%20anything%20using%20Metric%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%2F%2F%20count%20cores%20on%20each%20computer%2C%20exclude%20_total%20with%20regex%0APerf%0A%7C%20where%20CounterName%20%3D%3D%20%22%25%20Processor%20Time%22%20%20and%20ObjectName%20%3D%3D%20%22Processor%22%0A%7C%20where%20InstanceName%20matches%20regex%20'%5B0-9%5D'%0A%7C%20summarize%20Cores%20%3D%20dcount(InstanceName)%2C%20CoreList%20%3D%20make_set(InstanceName)%20by%20%20Computer%3C%2FPRE%3E%3CP%3E%26nbsp%3BThanks%2C%3C%2FP%3E%3CP%3EVinayaka%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi Everyone,

 

Background: We have more than terabytes of data we've collected over the last week. We've stopped the collection this week. And we now have 30 days to either pull the data and put it somewhere (I'm not sure if that's even possible in LogAnalytics), or we query and get as much information as possible.
We are building out a new VM environment, but the specs are still unknown. We would like to use the data we've collected to the baseline specs.

 

So how much will each VM processor speeds/core, memory, and hard drive space.

And as a bonus, what process they are running that are being used (im not sure if the performance data will get this.)

 

 

5 Replies
Highlighted

@rockypabillore 

 

Hi, what Data Tables do you have, that is more important than your capacity of Logs at this stage?

 

I'm assuming you have the Perf table?  If so what Perf counters are you collecting?   This will show the tables in use, can you share the results?

 

search *
| summarize count() by $table
| sort by count_ desc  

This will all list any counters you have collected:

Perf
| summarize count() by CounterName
| sort by count_ desc  

 

 

 

 

If you do have Perf, and this specific counter then you can get cores?

 

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"
| where InstanceName matches regex @'[0-9]'
| summarize Cores = dcount(InstanceName), CoreList = make_set(InstanceName) by  Computer

If you have this table, then you could get cores, speed and memory?

 

 

ServiceMapComputer_CL
| distinct Computer, Cpus_d, CpuSpeed_d, PhysicalMemory_d
| summarize cores = sum(Cpus_d),
            CpuSpeed = sum(CpuSpeed_d),
            PhysicalMemeory = sum(PhysicalMemory_d) 
  by Computer 

 

Disk space needs two Perf counters (if you want the in-use and disk capacity)

 

let myPCT =100;  // show all drives = 100 or show only drives below = nn %
Perf
| where CounterName == "Free Megabytes"
| where TimeGenerated > startofday(ago(1d))
| where InstanceName has ":" and strlen(InstanceName) ==2
// only look at drive letters
| summarize MbFree=avg(CounterValue) by Computer,InstanceName,bin(TimeGenerated, 5m)
| summarize arg_max(TimeGenerated, *) by Computer,InstanceName
|join kind= inner
(
    Perf
    | where CounterName == "% Free Space"
    | where TimeGenerated > startofday(ago(1d))
    | where InstanceName has ":" and strlen(InstanceName) ==2
    // only look at drive letters
| summarize PctFree=avg(CounterValue) by Computer,InstanceName,bin(TimeGenerated, 5m)
| summarize arg_max(TimeGenerated, *) by Computer,InstanceName
)
on Computer , InstanceName
| project   TotalSizeGB=round(MbFree*100/PctFree/1024,0),round(PctFree,2),round(MbFree,2),Computer,InstanceName
| where PctFree <= myPCT
// only shows drives with space below this value
| summarize FreePCT=avg(PctFree) by Computer,DriveLetter = InstanceName,TotalSizeGB,FreeGB = round(MbFree / 1024,2)
| sort by DriveLetter  asc
 
Example output
  Computer DriveLetter TotalSizeGB FreeGB FreePCT
DC02 C: 40 18.44 46.1

 

 

If you had VMconnection then this would work to look at Processes?

 

 

// show bytes per process by Computer
VMConnection
| summarize count(BytesSent), count(BytesReceived), make_set(ProcessName)  by  Computer

 

 

 

Highlighted

@Clive WatsonThanks for the suggestions! here's the list that I've been pulling: image.pngimage.png

 

When I run the Core Counts its giving me this:

image.png

 

Is that right?

 

I'm also getting no results for the hard drive space query:

 

image.png

 

Highlighted

Hi @rockypabillore 

 

He is an updated cores query, that should work better? 

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), CoreList = make_set(InstanceName) by  Computer

or

Perf
| where CounterName == "% Processor Time" and ObjectName == "Processor"
| where InstanceName matches regex @'[0-9]'
| summarize Cores = dcount(InstanceName) by  Computer
| sort by Cores desc 
| render barchart 

 

It doesn't look like you have "free megabytes" counter, so the query just needs to be:

 

let myPCT = 100;
Perf
| where CounterName == "% Free Space"
| where TimeGenerated > startofday(ago(1d))
| where InstanceName has ":" and strlen(InstanceName) ==2
// only look at drive letters
| summarize PctFree=round(avg(CounterValue),2) by Computer,InstanceName
| where PctFree <= myPCT
| sort by PctFree  desc 

 

Highlighted

Hi @Clive Watson 

 

with the help of below query can I get the Cores Utilization.?

I was refering to the Article : https://docs.microsoft.com/en-us/azure/azure-monitor/platform/metrics-supported

 

But I couldn't make anything using Metric as well.

 

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), CoreList = make_set(InstanceName) by  Computer

 Thanks,

Vinayaka 

Highlighted

@Vinayaka2210 

// count cores on each computer, exclude _total with regex
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), pctbyCore= sum(CounterValue) by  Computer, InstanceName


// count cores on each computer, exclude _total with regex, every 6 hrs 
Perf
| where CounterName == "% Processor Time"  and ObjectName == "Processor"
| where InstanceName matches regex '[0-9]'
| summarize Cores = dcount(InstanceName), pctbyCore= sum(CounterValue) by  Computer, InstanceName, bin(TimeGenerated,6h)