- 论坛徽章:
- 0
|
请问如何从文本信息获取满足 ptempdb_pages >= 10 的 spid?
例如,如下文本信息中,满足要求的是 spid 3 (ptempdb_pages = 10 )和spid 4 (ptempdb_pages = 20 )。
******** Active PSS Structures ********
spid: 1, kpid: 1361641792, pss: 0x1002dc78e48, proc: 0x10034c22ea8
pmemusage: 3, ptempdb_pages: 3
User: NMSuser, Command: 0 AWAITING COMMAND
Status: (0x00010000 (P_USERPROC))
*****************************************
spid: 2, kpid: 327685, pss: 0x1002dc8e888, proc: 0x10034bb6050
pmemusage: 0, ptempdb_pages: 0
Command: 0 DEADLOCK TUNE
Status: (0x00000200 (P_SYSTEMPROC))
*****************************************
spid: 3, kpid: 393222, pss: 0x1002dca42c8, proc: 0x10034bb65d8
pmemusage: 0, ptempdb_pages: 10
Command: 0 ASTC HANDLER
Status: (0x00000200 (P_SYSTEMPROC))
*****************************************
spid: 4, kpid: 458759, pss: 0x1002dcb9d08, proc: 0x10034bb6b60
pmemusage: 0, ptempdb_pages: 20
Command: 0 ASTC HANDLER
Status: (0x00000200 (P_SYSTEMPROC))
*****************************************
spid: 5, kpid: 524296, pss: 0x1002dccf748, proc: 0x10034bb70e8
pmemusage: 0, ptempdb_pages: 0
Command: 0 ASTC HANDLER
Status: (0x00000200 (P_SYSTEMPROC))
*****************************************
|
|