Spotlight on SAP ASE 2.12 - User Guide

Problem Users

This value shows the number of users that meet the criteria defined in Spotlight as being of concern.

To customize criteria

Select Views | Options | Spotlight® on SAP ASE | Problem User Definition.

The default criteria will count any process blocking another process for more than 30 seconds.

The other criteria that can be defined are listed below:

Pre v12.5.03:

• CPU utilization

• I/O utilization

• Memory utilization

• Block Threshold

v12.5.03 +:

• CPU Utilization

• Wait

• Physical reads

• Logical reads

• Physical writes

• Memory Allocated

• Locks Held

• Pages w/Index

• Pages w/o Index

• Transactions