我正在尝试分析sp_sysmon的输出,问题是工作进程的数量为空,下面是查询:
sp_sysmon begin_sample
go
select top 1000 * from BEVENTS
go
sp_sysmon end_sample, wpm这是输出:
Worker Process Requests
Total Requests 0.0 0.0 0 n/a
Worker Process Usage
Total Used 0.0 0.0 0 n/a
Max Ever Used During Sample 0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0 0 n/a 发布于 2012-08-22 22:55:34
拥有0个工作进程请求本身并不是问题。但是,如果您想要查看它们,请在sp_sysmon运行期间运行dbcc checkstorage。
https://stackoverflow.com/questions/11880652
复制相似问题