SQL Server Performance

Rowcount returned from Profiler trace

Discussion in 'SQL Server 2008 General DBA Questions' started by anilksharma99, Jul 26, 2009.

  1. anilksharma99 New Member

    SQL server version 10.0.1600.22 (X64)
    I am executing several stored procedures thru SSMS and other utility., rows returned to client are 1580 but profiler column reports it different 2199. Same behaviour shown by other procs as well. What is the reason and how to resolve this, as I recall SQL2005 reported correct rowcount number. I have to execute thousands of such procedures with diffrent parameters and capture the rowcount values for one of my tests.
    Also, let me know if there are other ways to find correct rowcount number.
    Thanks in advance.
  2. anilksharma99 New Member

    Does anyone has any clue on this? Any link/pointer will be helpful. Thanks

Share This Page