title: SP_WhoIsActive - Writes Column
body: <p>I was under the impression that the writes column in sp_whoisactive should show the number of writes applied to a table that SPID has completed.</p>
  
  <p>However I am testing this and not getting the expected results.</p>
  
  <p>I created a table with one column with datatype varchar(50)</p>
  
  <p>Wrote a loop to insert into into the table every 5 seconds,  in a separate query window I am calling sp_whoIsActive,  but the number of writes is not matching?</p>
  
  <pre><code>DECLARE @Wait INT = 1
  DECLARE @Counter INT = 0 
  WHILE @wait = 1
          BEGIN
  
  
  
              INSERT INTO tomTest
                    ( Data )
              VALUES('tom' + LTRIM(RTRIM(STR(@Counter))))
  
              SELECT @Counter = @Counter + 1
              WAITFOR DELAY '00:00:05'
          End
  </code></pre>
  
  <p>Thanks for your help</p>
  
  <p>Tom</p>