How to xperf on a particular process? or load symbols for different version of sql server?

hello,

we have both sql server 2012 , sql server 2014 running on windows 2012 r2, , there cpu spike issue, tried use xperf , windows performance recorder, etl file loads symbols sql serer 2014 properly.

since didn't work, found symbols from http://msdn.microsoft.com/en-us/windows/hardware/gg463028.aspx, , set symbol path installation folder, , not load symbols both sql server.

then thought if xperf on particular process, pid 1187792 normal process id wanted check if command works or not.

c:\performancework>xperf -start heapsession -heap -pids 1187792 -buffersize 1024 -minbuffers 128 -maxbuffers 128 -stackw
alk heapalloc+heaprealloc

c:\performancework>xperf -stop heapsession -d heaptrace.etl
merged etl: heaptrace.etl
the trace have captured "heaptrace.etl" may contain identifiable information, including not nece
ssarily limited paths files accessed, paths registry accessed , process names. exact information depends on t
he events logged. please aware of when sharing out trace other people.

but ended nothing, cannot see in etl file ( "unknown" in process column).

i tried use -pidnewprocess got same result.

c:\performancework>xperf -start heapsession -heap -pidnewprocess "notepad.exe" -buffersize 1024 -minbuffers 128 -maxbuff
ers 128 -stackwalk heapalloc+heaprealloc

c:\performancework>xperf -stop heapsession -d heaptrace.etl
merged etl: heaptrace.etl
the trace have captured "heaptrace.etl" may contain identifiable information, including not nece
ssarily limited paths files accessed, paths registry accessed , process names. exact information depends on t
he events logged. please aware of when sharing out trace other people.

can advise if there way xperf on particular process? or load symbols different sql server in 1 etl file?

thanks,

albert

Windows Server  >  Windows Server 2012 General