Performance Analyst Options Dialog Box

From RapidSQL
Jump to: navigation, search

Go Up to Using Performance Analyst

The Performance Analyst Options dialog box is where you can specify various refresh intervals, threshold polling, and datasource overrides among other settings. You can set or change defaults that are both global and platform-specific.

Note: The settings on the Global and Datasource tabs apply to all datasource platforms. The SQL Server, Sybase ASE, and DB2 tab settings are platform-specific. Some options on the platform-specific tabs may look as if they are available to you, but in reality they are not. For example, if you are connected to an Oracle datasource, changing the Monitoring Refresh interval on the Sybase tab is a hollow gesture.

To open the Performance Analyst Options dialog box

  • Open the Performance Analyst and then scroll down to Options on the drop-down menu.
  • Right-click in the Performance Analyst window for the target datasource and select Options.
  • Move your mouse over the Performance Analyst toolbar and click the multicolored square (you’ll see Options appear in a tool tip under the hand icon).

The table below describes the tabs of the Performance Analyst Options dialog:

Tab Settings Group Option/Description

Global

Engine

SQL metric refresh interval - Lets you set the time, in seconds, between collect cycles for the SQL metrics reflected in Performance Analyst. SQL metrics include all non-operating system metrics. OS metric refresh interval - Lets you set the time, in seconds, between collect cycles for all operating system-related metrics reflected in Performance Analyst. OS metrics include all metrics shown on the OS page. Threshold polling - Lets you determine which metrics, if any, you want to test against your pre-set thresholds. The possible settings for the Threshold polling box are: All Metrics - Polls all metrics Current Page Only - Polls only those metrics reflected on the currently open page in Performance Analyst Off - Turns polling off. If polling is turned off, Performance Analyst does not activate Alarms. Threshold polling interval - Lets you set the time, in seconds, between collect cycles for threshold-related metrics. Once collected, the polled metrics are compared to the pre-set thresholds. If you select Off in the Threshold polling box, Performance Analyst does not poll these metrics, regardless of the interval. Run queries for all tabs - Lets you determine whether or not you want Performance Analyst to refresh all tabs according to the SQL metric refresh interval. If Run queries for all tabs is not checked, Performance Analyst runs queries only for the current tab.

Visual

Show alarms icon in system tray - Lets you determine whether or not you want Performance Analyst alarms to appear in the Windows System Tray on the lower right-hand side of your screen. If you select Show alarms icon in system tray, Performance Analyst places an icon in the Windows System Tray each time an alarm is raised. Number of Historic Values in Graphs - Lets you specify the number of values in the graphs.

Datasource

Operating System

OS type - Lets you select the operating system type for the current datasource. The options are: MS Windows - Select MS Windows for all supported types of Microsoft Windows Unix or Linux - Select Unix or Linux if you operating system is any flavor of Unix Host name - Lets you specify the name of the host for the current datasource, if necessary. Performance Analyst automatically fills in any detectable information, including the Host name box. Username - Lets you select a local or network username that Performance Analyst can use to connect to the datasource. If you select the Use Datasource Username and Password check box, the Username box is unavailable. Password - Lets you select a local or network password that Performance Analyst can use to connect to the datasource. If you select the Use Datasource Username and Password check box, the Password box is unavailable. Protocol - Lets you specify a protocol for communicating with datasources on Unix-based operating systems. The options are: SSH Telnet Rlogin Use Datasource Username and Password - Lets you specify whether or not you want to use the datasource username and password to connect to the datasource as opposed to a network or operating system username and password Save Username and Password - Lets you save the username and password that appear in the Username and Password boxes.

Overrides

SQL metric refresh interval - Lets you override the SQL metric refresh interval in the Global tab for the current datasource. The SQL metric refresh interval specifies the time, in seconds, between collect cycles for the SQL metrics reflected in Performance Analyst. SQL metrics include all non-operating system metrics. OS metric refresh interval - Lets you override the OS metric refresh interval in the Global tab for the current datasource. The OS metric refresh interval specifies the time, in seconds, between collect cycles for all operating system-related metrics reflected in Performance Analyst. OS metrics include all metrics shown on the OS page.

SQL Server

Global Options

SQL Profiling Enabled - Performance Analyst requires some privileges that go along with SQL Server Profiler in order to return some statistics for SQL Server databases. Check SQL Profiling Enabled to ensure that Performance Analyst can collect all the necessary metrics.

New Datasource Defaults

Start SQL Profiling - Lets you set new datasources to start SQL Profiling when they are monitored by Performance Analyst. SQL Profiling refresh interval - Lets you set the default time for new datasources, in seconds, between collect cycles for the SQL metrics that require the SQL Server Profiler.

Current Datasource Settings

Start SQL Profiling - Lets you set current datasources to start SQL Profiling when they are monitored by Performance Analyst. SQL Profiling refresh interval - Lets you set the default time for current datasources, in seconds, between collect cycles for the SQL metrics that require the SQL Server Profiler.

Sybase

Global Options

Monitoring Table refresh interval - Lets you specify, in seconds, the amount of time between refreshes for the Monitoring Table. The Monitoring Table is a table installed by Performance Analyst used to store various metric-related information. The default is 15 seconds.

New Datasource Defaults

Use noclear option in sp_sysmon - Performance Analyst sessions are started with the ‘sp_sysmon noclear’ option, ensuring that monitor values are stored in a temporary file. If monitoring is being used by another application, those results are not impacted by the Performance Analyst session zeroing out counters. NOTE: The noclear option is available for Sybase ASE 12.5.3 and higher and 15.0.2 and higher.

Current Datasource Defaults

These settings are only available with a Performance Analyst session active against a Sybase ASE datasource. The settings only apply to current sessions. The Monitoring Table refresh interval and Use noclear option in sp_sysmon settings let you override the selections in the identically-named settings in the Global Options and New Datasource Defaults groups. Use custom sample query - You can use this option to build a custom sampling query and check the database response time by reviewing the Sample Query Response Time graph on the Database home page.

DB2

Monitor Settings

Monitor Switches - You are able to set monitor switches ON for the current session. When check marks are visible, that means they were previously set as defaults. Check or uncheck the boxes as you wish. Monitor settings are available for Buffer Pool. Statement, Lock, Table, Sort, Unit of Work. Metrics for all checked elements are gathered in the current session. SQL Statement Cache - You can collect SQL statements on each refresh, collect SQL statement only when you are on the Top SQL pages, or choose not to collect any SQL statements. Database System Monitor Heap - The database system monitor heap size shows the current value, in pages, allocated for the database system monitor data. The amount of memory required for monitoring depends on the number of monitoring applications, switch settings, and the level of database activity. If you see frequent heap overflow errors in the output message window when monitoring DB2 through Performance Analyst, adjust the setting here. Save settings as default - Gives you the option to set the monitoring settings as a default for the current DB2 database or for the current session only.