Get ElastiCube from Process ID
Question
I would like to be able to track memory consumption of my ElastiCubes, but I can't find an easy way to link the process ID of my ElastiCube to the cube name.
Answer
If you open the Task Manager, go to the Details tab and right-click on one of the columns then click on the Select columns option. Find the Command line option.
Still on the Details tab, if you search for ElastiCube.exe processes, you can see the ElastiCube name as one of the process arguments (dbname)
You can use the following PowerShell (make sure to run as Admin) script to extract all of these into a CSV file:
$process = "elasticube.exe"
Get-CimInstance Win32_Process -Filter "name = '$process'" | Select CommandLine | Export-Csv -Path "c:\temp\reports.csv"
Updated 02-23-2024
