Show row count in SQL Profiler

Can I show the "Row Count" column in a SQL Server profile?

For example, there are CPU and Duration columns, but can it show how many rows the query returns?

+4
source share
3 answers

How about using a RowCounts column?

+9
source

For SQL Server 2008 R2 :
In the top menu: Tools -> SQL Server Profiler
Select server name:

enter image description here

The Trace Properties dialog box appears.
Go to the Events Selection tab:

Events selection

Check Show all columns
Slide the horizontal scroll bar to the right.
Check the boxes below the RowCounts column.

enter image description here

Click Run

Tracing starts to appear. The RowCounts column will be on the right. You can drag it to the left if you want.

+3
source

Quite simple, no. It is not measurable in the profiler

-2
source

Source: https://habr.com/ru/post/1301109/


All Articles