How do I work out how much data a stored procedure returns?

Question

How do I work out how much data (in KB) a stored procedure returns? I can't see a column in profiler that might indicate this, other than Binary Data.

Can I do it with a SQL Server tool like profiler, or should I use something like Wireshark?

Answer 1

Run the stored procedure in SQL Server Management Studio with "Include Client Statistics" selected. The Client Statistics tab in the results pane will include a figure for "Bytes received from server."

Answer 2

Right click th empty space in SSMS.and select the Include Client Statistics

Bytes received from server – is the amount of data the SQL Server has sent to the client, measured in bytes