Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to measure in KB store proc response?

Author  Topic 

don_marko
Starting Member

5 Posts

Posted - 2009-01-20 : 09:52:51
I need to find out how to measure store procedure response size in KB?
Is there any methods except of viewing it in "Execution plan" where the size is only approx....

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-20 : 12:04:41
size of what you mean? response data?
Go to Top of Page

don_marko
Starting Member

5 Posts

Posted - 2009-01-21 : 02:31:45
yes, I mean this. I need to find out response data...
Go to Top of Page

don_marko
Starting Member

5 Posts

Posted - 2009-01-21 : 03:08:01
Actually I found one. Before store procedure execution you need to turn on "Include Client Statistics" (Shift+Alt+S), after execution you'll see this statistic on the second tab(near result tab)...

If there any others methods that helps to gather this statistic(response data size) for period of time?
Go to Top of Page
   

- Advertisement -