Manage and Monitor the Adaptive Server Environment

Monitor the performance, processes, databases, and other aspects of Adaptive Servers.

• Managing an Adaptive Server
  Sybase Control Center allows you to register and authenticate a running an agent, start and stop your server, and view the server error log.
• Displaying the Performance Overview
  The Overview screen shows Adaptive Server performance status.
• Caches
  Monitor Adaptive Server data, procedure, statement caches, and in-memory storage.
• Clusters
  
• Compiled Objects
  A compiled object is any object that requires entries in the sysprocedures table.
• Databases
  Monitor Adaptive Server databases.
• Defaults
  Create and modify defaults using the Sybase Control Center Administration Console.
• Devices
  Monitor the devices used by Adaptive Server.
• Engines
  
• Execution Classes
  Use the Administration Console to manage execution classes.
• Extended Stored Procedures
  Create, delete, modify, and administer extended stored procedures using the Sybase Control Center Administration Console.
• Functions
  Manage scalar and SQLJ functions using the Sybase Control Center Administration Console.
• Networks
  Manage remote servers.
• Precomputed Result Sets
  
• Procedures
  Manage stored and SQLJ procedures using the Sybase Control Center Administration Console
• Processes
  Monitor Adaptive Server processes.
• Replication Agents
  Set replication parameters and monitor repAgent threads in Adaptive Server.
• Rules
  Manage rules using the Sybase Control Center Administration Console.
• Security
  Use server-level security features such as logins, login profiles, and roles, and database-level security features such as encrypted columns, users, and groups.
• Segments
  Monitor the segments used by Adaptive Server databases.
• Server Configuration
  Display and monitor Adaptive Server configuration values.
• Settings
  Learn about Adaptive Server monitoring controls on the Settings screen.
• Statistics
  Availability and performance statistics in Sybase Control Center for Adaptive Server can help you determine whether your systems are running as efficiently as possible.
• SQL Activity
  Monitor SQL queries on Adaptive Server.
• Tables
  Manage tables used by Adaptive Server databases.
• Thread Pools
  Monitor threads or manage thread pools into groups of CPU resources.
• Transactions
  
• User-Defined Datatypes
  From the Perspective Resources view, use the Administration Console option on your Adaptive Server to create user-defined datatypes and view their properties.
• Views
  Manage Adaptive Server views using the Sybase Control Center Administration Console.