开发者

How to view ActualNumberOfRows in SQL Server execution plan

开发者 https://www.devze.com 2023-02-09 19:06 出处:网络
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

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

精彩评论

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