Is it possible to show a "Row Count" column in SQL Server Profiler?
For example there are CPU and Duration columns but can it show how many rows a query returns?
Asked
Active
Viewed 6,158 times
3 Answers
13
How about using the RowCounts column?
Ed_E
- 154
- 1
- 3
-
1Yes thanks that's what I was looking for. I did not see the column because I did not click "Show all columns" :) BTW, here I found this video demonstrating it: http://www.sqlshare.com/media.aspx?vid=829& – Kobus Smit Nov 16 '10 at 14:59
-
I see my original question was tagged sql-server-2000. I don't think that column was available in that old version of SQL Server. – Kobus Smit Nov 16 '10 at 15:09
7
For SQL Server 2008 R2:
From the top menu: Tools -> SQL Server Profiler
Choose the Server name:
The Trace Properties dialog will appear.
Click on the Events Selection tab:
Click on the Show all columns check box
Slide the horizontal scroll bar to the right.
Check the boxes under the column RowCounts
Click Run
The trace will start displaying. The RowCounts column will be to the very right.
You can drag it to the left if you so desire.
Al Lelopath
- 6,448
- 13
- 82
- 139
-2
Quite simply, no. It's not a measurable in profiler
gbn
- 422,506
- 82
- 585
- 676
-
That's unfortunate, would have been really helpful to navigate through lots of Profiler entries by looking at a "Row Count" column. – Kobus Smit Feb 17 '10 at 16:05
-
1
-
-
@Mike Forman: Thanks I must have missed that before. It's indeed useful! – Kobus Smit Nov 16 '10 at 14:57
-
I see my original question was tagged sql-server-2000. I don't think that column was available in that old version of SQL Server. – Kobus Smit Nov 16 '10 at 15:06