Set a Maximum Table Size for a Trace Table (SQL Server Profiler)
Applies to: SQL Server Azure SQL Managed Instance
This topic describes how to set a maximum table size for trace tables by using SQL Server Profiler.
To set a maximum table size for a trace table
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.
In the Trace name box, type a name for the trace.
In the Template namelist, select a trace template.
Select the Save to tablecheck box.
Connect to the server on which you want the trace to be stored.
The Destination Table dialog box appears.
Select a database for the trace from the Database list.
In the Table box, type or select a table name.
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
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho