SQL Server Profiler - Tools/Options (General Options Page)
Use the General Options dialog box to view or specify the following 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 SQL Server, which includes milliseconds.
- Show values in Duration column in microseconds (SQL Server 2005 only)
Displays the values in microseconds in the Duration data column of traces. By default, the Duration column displays values in milliseconds.
- 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 SQL Server when the provider is updated. This item is not checked by default. This forces SQL Server Profiler 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 SQL Server Profiler prompt you before adding a rollover file when a trace file is opened.
- Never load subsequent rollover files
SQL Server Profiler never loads subsequent rollover files when a trace file is opened.
- 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.
Other ResourcesHow to: Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)
How to: Set Trace Display Defaults (SQL Server Profiler)
How to: Replay a Trace Table (SQL Server Profiler)
How to: Replay a Trace File (SQL Server Profiler)
How to: Set Global Trace Options (SQL Server Profiler)
Using SQL Server Profiler
Introducing SQL Server Profiler
SQL Server Profiler Reference