Feature Request

Adding SqlServer Process ID to ServerProperties metrics

Proposal:

Adding SERVERPROPERTY('ProcessID') can help for correlation between win_perf_counters metrics and SqlServer Process counters and the corresponding SQL Server instance

Current behavior:

Currently there is no way to correlate CPU usage in interval of seconds

Desired behavior:

Having the ProcessID of the sqlservr process from ServerProperties query V2

Use case:

In a scenario where there is one SQL instance installed on a Windows Server, correlation with Win process counters is easy because there is only one instance of the sqlserver process. However, the current proposal would be helpful for SQL multi-instances scenarios due to multiple instances of the sqlservr process in win_perf_counters making the correlation between Win process counters and the corresponding SQL Instances impossible without the correct Process ID.