立即与支持人员聊天
与支持团队交流

Spotlight on SAP ASE 2.11 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Set number of rows for data return

To set the maximum number of rows of data that will be returned for a query, select View | Options | Spotlight® on SAP ASE | Acquisition.

The following window is displayed:

To set the upper limit for the number of rows of data that will be returned by a query to the Adaptive Server, do the following:

  1. In the Row Limit field, type (or scroll to) the maximum number of rows that you want returned.

    Note: The default number of rows is 1000.

  1. If you do not want the Backup Server to be polled, click the check mark in the Poll Backup Server field to remove it. Otherwise, leave the check mark in place.

    Notes:

  • If the Backup Server is down, the system will attempt to poll it. Then, if no connection can be made to the Backup Server, a line will be written to the Adaptive Server's Error Log every time an unsuccessful poll attempt is made.
  • There may be times when there is a planned long-term outage of a backup server. To curtail the volume of messages written to the Adaptive Server Error Log, you can uncheck this box.
  1. If desired, you may insert one or more queries in the Benchmark Query field in addition to, or in place of, the default query displayed.

    Notes:

  • Any query entered will have the execution times measured and returned to the Response Time component on the Home Page.
  • If a complex or lengthy query is entered, the other queries submitted by Spotlight will be impacted.
  1. Click OK.

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级