开发者

How to view ActualNumberOfRows in SQL Server execution plan

I've been trying to diagnose a performance issue in my database and have googled a lot on maxdop. I have seen in many places where ActualNumberOfRows, ActualRebinds etc. are shown in properties view but the first thing I开发者_开发问答 see is DefinedValues.

After running execution plan I right click an Index Scan for example and expect to see these fields so I can determine how rows are distributed amongst threads.

I am using SQL Server 2005 Enterprise.


include the Actual Execution plan and in that click on the arrow button, there we can see the Actual Number of Rows

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜