“暂停"状态是什么意思?高 DiskIO 意味着来自 sp_who2? [英] What does a Status of "Suspended" and high DiskIO means from sp_who2?

问题描述

我正在尝试解决我们应用程序中的一些间歇性减速问题.我有一个单独的问题 此处 了解更多详情.

I'm trying to troubleshoot some intermittent slowdowns in our application. I've got a separate question here with more details.

我运行了 sp_who2，我注意到一些连接状态为 SUSPENDED 和高 DiskIO.有人可以向我解释一下这意味着什么吗?

I ran sp_who2 to and I've noticed a few connections that have a status of SUSPENDED and high DiskIO. Can someone explain to me what that indicates?

推荐答案

这是一个非常广泛的问题，所以我将给出一个广泛的答案.

This is a very broad question, so I am going to give a broad answer.

1. 查询在请求访问当前不可用的资源时被暂停.这可以是逻辑资源(如锁定行)或物理资源(如内存数据页).一旦资源可用，查询将再次开始运行.
2. 高磁盘 IO 意味着需要访问大量数据页才能满足请求.

这就是我从上面的屏幕截图中可以看出的全部内容.但是，如果我推测，您可能有一个 IO 子系统太慢而无法满足需求.这可能是由于缺少索引或磁盘实际上太慢造成的.请记住，单个 OLTP 查询的 15000 次读取略高，但并不少见.

That is all that I can tell from the above screenshot. However, if I were to speculate, you probably have an IO subsystem that is too slow to keep up with the demand. This could be caused by missing indexes or an actually too slow disk. Keep in mind, that 15000 reads for a single OLTP query is slightly high but not uncommon.

这篇关于“暂停"状态是什么意思?高 DiskIO 意味着来自 sp_who2?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！