title: SQL Server 2008: A *Data File IO counter* for SQL Server
body: <p>I make a stress test of the SQL Server 2008 and I want to know what is the data flow to tempdb because of usage of temporary tables and variables.</p>
  
  <p>The statistics is also shown in Activity Monitor:</p>
  
  <p><img src="https://i.stack.imgur.com/ynPyI.png" alt="enter image description here"></p>
  
  <p>Is it possible somehow to record the data and afterwards analyse it?
  I have 2 cases in mind:</p>
  
  <ol>
  <li>Record an SQL Server counter (I don't know which is the name for it)</li>
  <li>Record somehow data from Activity Monitor</li>
  </ol>