Skip to content

save-trace-results-to-a-table-sql-server-profiler.md

Latest commit

 

History

History
47 lines (31 loc) · 2.05 KB

save-trace-results-to-a-table-sql-server-profiler.md

File metadata and controls

47 lines (31 loc) · 2.05 KB
title Save Trace Results to a Table
titleSuffix SQL Server Profiler
description Learn how to use SQL Server Profiler to save trace results to a table in a SQL Server database. Find out how you can specify the maximum number of rows to save.
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology profiler
ms.topic conceptual
ms.assetid edbecf74-683b-4e43-a1ef-7a3d5f5e27f6
author markingmyname
ms.author maghan
ms.custom seo-lt-2019
ms.date 03/14/2017

Save Trace Results to a Table (SQL Server Profiler)

[!INCLUDE SQL Server]

This topic describes how to save trace results to a database table by using [!INCLUDEssSqlProfiler].

To save trace results to a table

  1. On the File menu, click New Trace, and then connect to an instance of [!INCLUDEssNoVersion].

    The Trace Propertiesdialog box appears.

    [!NOTE]
    If Start tracing immediately after making connectionis selected, the Trace Propertiesdialog box fails to appear and the trace begins instead. To turn off this setting, on the Toolsmenu, click Options, and clear the Start tracing immediately after making connection check box.

  2. In the Trace name box, type a name for the trace, and then click Save to table.

  3. In the Connect to server dialog box, connect to the [!INCLUDEssNoVersion] database that will contain the trace table.

  4. In the Destination Table dialog box, select a database from the Databaselist.

  5. In the Owner list, select the owner for the trace.

  6. In the Table list, type or select the table name for the trace results. Click OK.

  7. In the Trace Properties dialog box, select the Set maximum rows (in thousands) check box to specify the maximum number of rows to save.

See Also

SQL Server Profiler