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
 SQL Server Administration (2005)
 profiler recordset sizes

Author  Topic 

jdubs78
Starting Member

1 Post

Posted - 2007-04-09 : 14:22:31
I am currently working the database side of a project that uses stored procedures to retrieve, insert, and update records in the database. I would like to get an average of how long it takes for each procedure to perform its functions on a given amount of data. I can use profiler to capture the number of rows that the procedure processed but I don't see how I can get the size (in bytes or MB, whatever) of that recordset. Does anyone know of a way to do this or of something better than profiler to use?
   

- Advertisement -