CODEWITHSUNDEEP
sql-serversql-server-2012
ausgeorge
ausgeorge

Reputation: 1015

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

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?

Upvotes: 3

Views: 113

Answers (2)

Nagaraj S
Nagaraj S

Reputation: 13484

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

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

enter image description here

Upvotes: 3

Ian Nelson
Ian Nelson

Reputation: 58753

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."

Upvotes: 5

Related Questions