大家在查： •菲拉罗 spent bullet 决定不再 reify 艾尔加凝液 Mikenuosl 欧迪兹 ciliotoxicity 生存质量

ROWS_READ

ROWS_READ

ROWS_READ

ROWS_READ

1

Scroll down in the Select counters section to select Rows read and Rows selected, as shown in Figure 12 .

在 Selectcounters 部分中向下滚动，找到并选择 Rowsread 和 Rowsselected ，如图 12 所示。

2

Method with all forward-only cursor types returns the number of rows read so far through the cursor .

方法都会返回目前已通过游标阅读的行数。

3

From the right side of the System Health window , right-click SQL , and select Rows read vs Selected.

从 SystemHealth 窗口的右侧，右键单击 SQL ，选择 RowsreadvsSelected 。

4

ROWS_READ: Total number of rows read during the execution of the statement .

ROWS_READ ：在执行语句期间，所读取的总行数。

8

Here is how to create a customized System Health data view that compares the number of rows read to the number of rows selected.

下面介绍如何创建自定义的 SystemHealth 数据视图，这个视图比较读取的行数与选择的行数。

9

The number of rows read (7700000 ) versus the number of rows written (77 ) show that a table scan is likely happening .

行读取的数目（77 ）表明很可能发生表扫描。

10

Look for high rows read or written.

寻找被频繁读写的行。

热词推荐

大家在看