set-a-maximum-table-size-for-a-trace-table-sql-server-profiler.md

title	Set a Maximum Table Size for a Trace Table (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date	03/01/2017
ms.prod	sql-non-specified
ms.prod_service	sql-tools
ms.service
ms.component	sql-server-profiler
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	size [SQL Server], trace tables maximum table size for traces
ms.assetid	d0ae83e5-1c88-4a2e-be05-2c341280b978
caps.latest.revision	23
author	stevestein
ms.author	sstein
manager	craigg
ms.workload	Inactive

Set a Maximum Table Size for a Trace Table (SQL Server Profiler)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to set a maximum table size for trace tables by using [!INCLUDEssSqlProfiler].

To set a maximum table size for a trace table

1. On the File menu, click New Trace, and then connect to an instance of SQL Server.

   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.

3. In the Template namelist, select a trace template.

4. Select the Save to tablecheck box.

5. Connect to the server on which you want the trace to be stored.

   The Destination Table dialog box appears.

6. Select a database for the trace from the Database list.

7. In the Table box, type or select a table name.

8. Select the Set maximum rows check box, and specify a maximum number of rows for the trace table.

   [!NOTE]
   When the number of rows in the table exceeds the maximum that you have specified, the trace events are no longer recorded. However, tracing continues.

See Also

SQL Server Profiler
SQL Server Profiler