SQL Server Profiler - Tools/Options (General Options Page)

SQL Server Profiler - Tools/Options (General Options Page)

 

Applies To: SQL Server 2016

Use the General Options dialog box to view or specify the following options.

Display Options

Font name
Displays the name of the font used in the trace results grid during traces.

Font size
Displays the size of the font used in the trace results grid during traces.

Choose Font
Opens a dialog to change the font settings.

Use regional settings to display date and time values
Displays date and time values in regional settings configured for your computer. If you do not select this option, the date and time values are displayed in the fixed format used by Microsoft Entity with relative path '../Token/ssNoVersion_md.md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"a888246d-ccfe-415f-bbdc-d6adafac250a","entity_type":"Article","locale":"en-US"}'., which includes milliseconds.

System_CAPS_ICON_note.jpg Note


Toggling this checkbox changes the time columns display format such as StartTime and EndTime. However, it does not change the DateTime value parameters inside the language events or remote procedure calls (RPCs).

Show values in Duration column in microseconds
Displays the values in microseconds in the Duration data column of traces. By default, the Duration column displays values in milliseconds.

Tracing Options

Start tracing immediately after making connection
Begin a trace using the default template as soon as a connection is made.

Update trace definition when provider version changes
Apply the most current trace definition to Entity with relative path '../Token/ssNoVersion_md.md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"a888246d-ccfe-415f-bbdc-d6adafac250a","entity_type":"Article","locale":"en-US"}'. when the provider is updated. This item is not checked by default. This forces Entity with relative path '../Token/ssSqlProfiler_md.md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"a888246d-ccfe-415f-bbdc-d6adafac250a","entity_type":"Article","locale":"en-US"}'. to query the server for the trace definition and re-create, if one exists, the file on disk.

File Rollover Options

Load all rollover files in sequence without prompting
Load rollover files automatically when a trace file is opened. If more than one file was created while tracing, selecting this option automatically loads all rollover files.

Prompt before loading rollover files
Have Entity with relative path '../Token/ssSqlProfiler_md.md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"a888246d-ccfe-415f-bbdc-d6adafac250a","entity_type":"Article","locale":"en-US"}'. prompt you before adding a rollover file when a trace file is opened.

Never load subsequent rollover files
Entity with relative path '../Token/ssSqlProfiler_md.md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"a888246d-ccfe-415f-bbdc-d6adafac250a","entity_type":"Article","locale":"en-US"}'. never loads subsequent rollover files when a trace file is opened.

Replay Options

Default number of replay threads
Specify the number of replay threads to use concurrently. A higher number consumes more resources during replay, but increases replay concurrency.

Default health monitor wait interval (sec)
Specify the wait interval to replay in seconds. Default is 3600 seconds (1 hour). This setting affects the amount of time a thread is allowed to run before being terminated by the health monitor.

Default health monitor poll interval (sec)
Specify the health monitor poll interval during replay in seconds. Default is 60 seconds. This value allows the user to configure how often the health monitor polls for candidates for termination.

Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)
Set Trace Display Defaults (SQL Server Profiler)
Replay a Trace Table (SQL Server Profiler)
Replay a Trace File (SQL Server Profiler)
Replay Traces
Set Global Trace Options (SQL Server Profiler)
SQL Server Profiler Templates and Permissions
SQL Server Profiler

Community Additions

ADD
Show:
© 2016 Microsoft