Selecting the time interval for SQL apps

Use the Time Intervals dialog to select the custom time period in which you need to investigate SQL errors or SQL performance issues. You can select multiple contiguous rows that define the start and end time used to display information in the applications. Use the following procedure to select the custom time interval for the SQL Errors or SQL Analysis applications.

Related topics

Troubleshooting SQL statements

To select the time interval for SQL apps

  1.  From the Timeframe list, select Custom Interval.
    The Time Intervals dialog is displayed with the current intervals already selected (CheckedSign-24.png).
  2. (Optional) Clear all selected intervals by performing the following steps:
    1. Click MinusSign-24.png.
      The Time Intervals dialog selects all displayed intervals.
    2. Click CheckedSign-24.png.
      The Time Intervals dialog clears all displayed intervals.
  3. To display additional intervals, click Show More. The Time Interval dialog refreshes the display with additional intervals. If no additional rows are available Show More is disabled.
  4. Select the interval rows within the time period you want to investigate. Selected rows must be contiguous. The Time Interval dialog will automatically select any cleared rows between the row you selected and another row already selected.
  5. Click OK to save your changes.
  6. Click Cancel to return to the application without saving your changes.
     

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*