Skip to content

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

Latest commit

 

History

History
43 lines (28 loc) · 1.9 KB

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

File metadata and controls

43 lines (28 loc) · 1.9 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.
author rwestMSFT
ms.author randolphwest
ms.date 06/05/2025
ms.service sql
ms.subservice profiler
ms.topic how-to
ms.collection
data-tools

Save trace results to a table (SQL Server Profiler)

[!INCLUDE SQL Server Azure SQL Managed Instance]

This article describes how to save trace results to a database table by using [!INCLUDE ssSqlProfiler].

Save trace results to a table

  1. On the File menu, select New Trace, and then connect to an instance of [!INCLUDE ssNoVersion].

    The Trace Properties dialog box appears.

    If Start tracing immediately after making connection is selected, the Trace Properties dialog box fails to appear and the trace begins instead. To turn off this setting, on the Tools menu, select 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 select Save to table.

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

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

  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. Select 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.

Related content