Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - 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

Locks Used

This is the number of locks in use on the ASE.  Use this value to both tune the number of locks configured on the server and as an indicator of activity on an ASE.

The default value for the "number of locks" configuration parameter is 5000.  Watch this value and the Error Log to make sure this number is not exceeded, and adjust it as necessary.

Locking affects performance of an ASE by limiting concurrency.  The number of locks used is only one measurement to track.  

Go to the Locksdrilldownto view detailed information on user and object lock activity.  This information should provide direction on choosing the appropriate locking schemes to be employed.

  

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating