On the database foglight page for a sql server database under CPU utilization there are two graph lines, one labeled "SQL Server" and one labeled "Total". what windows processes are monitored for CPU that fall under "SQL Server"?
Would the "databasemail90.exe " process CPU be listed under "SQL Server" or "Total" CPU?
1). The Total CPU is the overall operating system CPU usage (including SQL Server) using the Win32_PerfRawData_PerfOS_Processor WMI class by all Windows processes of all the host processors.
2). The SQL Server process ID is being querying by the following SQL:
Select ServerProperty ( 'ProcessID' ) as process_id
Once we have the PID, we query the WMI object with the following query:
Select Name,VirtualBytes, PercentProcessorTime,TimeStamp_Sys100NS from Win32_PerfRawData_PerfProc_Process where IdProcess = {0}
3). Databasemail90.exe is an external application to SQL Server which connects to the server using windows authentication and sends mail, so it would be included in Total CPU.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy