Chat now with support
Chat with Support

Benchmark Factory for Database 8.2.1 - User Guide

Getting Started Licensing Overview of Benchmark Factory Benchmark Factory Components Agents Create and Edit Connections Create and Edit Tests and Jobs Test Results and Run Reports Troubleshooting The Benchmark Factory REST API

Creating a SQL 2005 Trace Table Using the SQL Server Profiler

To create a SQL 2005 trace table

  1. Initiate the SQL Profiler.
  2. Click the New Trace icon. The Connect to SQL Server window displays.
  3. Select the appropriate server name from the drop-down list.
  4. Select the appropriate authentication from the drop-down.  Enter the login name and password if required.
  5. Click Connect. The Trace Properties window displays.
  6. Enter a name for the trace in the Trace name field.
  7. Check the Save to table check box. The Connect to Server dialog displays.
  8. Select the appropriate server name from the drop-down list.
  9. Select the appropriate authentication from the drop-down.  Enter the login name and password if required.
  10. Click Connect. The Destination Table window displays.
  11. Select the appropriate database from the Database drop-down list.
  12. Select the appropriate owner from Owner drop-down.
  13. Select the appropriate table from the Table drop-down list.
  14. Click OK. The Trace Properties window displays.
  15. Click the Events Selection tab.
  16. Verify that all check boxes are checked in the TSQL-SQL:BatchStarting Events, and TSQL-SQL:BatchComplete Events.
  17. Click Run.
  18. Run SQL statements.
  19. When finished running SQL statements, click the Stop selected trace icon. The table is created. 
Related Documents