Generating a CSV File on a Remote Server for Windows 7/2008 R2

Any performance counter log (CSV) file you specify in the command line tool must follow the format generated by the Windows Performance Monitor tool ( Administrative Tools > Performance ). So, before using csv2tsd.exe you must create a performance counter with settings that will allow you to import its data.

  1. Open the Windows Performance Monitor tool ( Administrative Tools > Performance ).
  2. Expand the tree Performance > Data Collector Sets > User Defined.
  3. Right-click and select New > Data Collector Set from the context menu.
  4. Enter a name and select Create manually (Advanced) and click Next.
  5. Create data logs and select Performance counter. Click Next.
  6. Specify the location of the CSV file and click Next.
  7. Optional: Specify a different user in Run as. Click Save and close the dialog box.
  8. Right-click on the defined Data Collector Set and select New > Data Collector from the context menu.
  9. Enter a name and select Performance counter data collector. Click Next.
  10. Click Add to add the performance counters.
  11. Specify the computer (can be both local and remote) and performance counter instances for which you want to track results.
  12. Select Open properties for this data collector and click Next.
  13. On the Performance Counters tab specify the log format to be Comma Separated.
  14. Select the File tab and specify a file name.
  15. Click OK to close the dialog.
  16. Close the Performance Monitor.
Once you have configured a performance counter so that its log results can be converted to TSD format using csv2tsd.exe, you can start capturing behavioral data using the performance counter.