Show Row Count in SQL Profiler

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?

  • TSQL: Tune Dynamic Query Search
  • Populating ComboBox with values from SQL Column
  • SQL Server 2005 user permissions
  • Match and compare two tables in SQL Server
  • Must declare scalar variable error
  • An expression of non-boolean type specified in a context where a condition is expected
  • 3 Solutions collect form web for “Show Row Count in SQL Profiler”

    How about using the RowCounts column?

    For SQL Server 2008 R2:
    From the top menu: Tools -> SQL Server Profiler
    Choose the Server name:

    enter image description here

    The Trace Properties dialog will appear.
    Click on the Events Selection tab:

    Events Selection

    Click on the Show all columns check box
    Slide the horizontal scroll bar to the right.
    Check the boxes under the column RowCounts

    enter image description here

    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.

    Quite simply, no. It’s not a measurable in profiler

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.