Contributions
Re: Writing Perfmon Counters to a csv file
Fantastic - Thanks! I got this working this morning. One key for anyone elsewhowants to use this:I had to run it signed in as Administrator rather than my normal ID with Admin rights. The script ran, but I got all zeros for values when I was not running as administrator. Also, I used your script to create two more so that I could write these out to a csv file for graphing andanalysis. It was a very simple matter, but I'm sharing them to save someone time ifthey are new to this or haven'tscripted in a while, as I haven't. Onescript writes the Counter Names (prop.Name) to the header row of a .csv file. I execute it before entering my Data-Driven or For Loop. The other onewrites out the Counter Values (prop.Value) to the .csv file within the loop. First Create csv File and Headers: Sub Write_CLRCountersToHeader ' My process name myProcess = "_Global_" ' You can specify your executable's name here, e.g. Orders computerName = "." ' You can specify your computer name here ' Connect to WMI via COM Set objWMIService = GetObject("winmgmts:\\" & computerName & "\root\cimv2") Set PerfProcess = objWMIService.Get( _ "Win32_PerfFormattedData_NETFramework_NETCLRMemory.Name='" & myProcess & "'") 'Creates a new file. Call aqfile.Create("FilePath\CLRCounters.csv") 'Change FilePath to the path to the directory where you want to put the file' ' Writes each propertyname to the CSV Header Line . s = "" For Each prop In PerfProcess.Properties_ s = s & prop.Name & "," Next Call aqFile.WriteToTextFile("FilePath\CLRCounters.csv", s & vbCrLf, 20)'Must be same path and filename as above End Sub Second Script Write CLR Counter Values to csv Within a Loop: Sub Write_CLRCounterValuesToCSV 'My process name myProcess = "_Global_ " ' You can specify your executable's name here, e.g. Orders computerName = "." ' You can specify your computer name here ' Connect to WMI via COM Set objWMIService = GetObject("winmgmts:\\" & computerName & "\root\cimv2") Set PerfProcess = objWMIService.Get( _ "Win32_PerfFormattedData_NETFramework_NETCLRMemory.Name='" & myProcess & "'") 'Writes each property to the CSV Header Line . s = "" For Each prop In PerfProcess.Properties_ s = s & aqConvert.VarToStr(prop.Value) & "," Next Call aqFile.WriteToTextFile("FilePath\CLRCounters.csv",s & vbCrLf, 20) End Sub1.4KViews0likes0CommentsWriting Perfmon Counters to a csv file
I am currently writing the time and memory usage to a csv file using aqfile and the following code statement: aqDateTime.Time() & "," & Sys.Process("MfgSys").MemUsage & vbCrLf As I am monitoring for memory issues caused by improper garbage collection, I would also like to display the .Net CLR memory counters that are available in Perfmon. In particulary, the size of the Gen 2 heap would be most useful - \.net CLR Memory (_Global_)\Gen 2 heap size I have not been able to find a way to access this counter so that I can write it to the same csv file. I have tried running as administrator and still am not able to find a way to get at this counter. Any suggestions?15KViews0likes2Comments- 13 years agoPlace AQtime QuestionsAQtime Questions725Views0likes0Comments
Unable to download standard tool
I filled in the exact same information that I filled in for DevPlanner and QAPlanner which allowed me to register and sign in successfully with those products. However, when doing so for AQtime and then submitting. Nothing occurs - the screen does nothing and I receive no e-mail.13 years agoPlace AQtime QuestionsAQtime Questions11KViews0likes2CommentsCheckpoint - Verifying Calculations with an equation
Is it possible to set a check point in a data-driven loop to verify that an on-screen value relates acurately to other on-screen values via an equation? For example - the value of the Total Charge Field = Value of Price Field - Value of Discount Field + Value of Tax Field + Value of Shipping Field? I looked through help and searched here, but did not find anything, though I just may not be searching on the right terms.16KViews0likes3Comments