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 Unified Agent, start and stop your server, and view the server error log.
• Displaying the Performance Overview
  The Overview screen shows Adaptive Server performance status.
• Clusters
  Monitor Adaptive Server cluster configurations. Monitored resources include memory usage, device I/O, engine CPU utilization, connection information, interprocess communication, workload management, load profiles, routes, and so on.
• Caches
  Monitor Adaptive Server data, procedure, statement caches, and in-memory storage.
• Databases
  Monitor Adaptive Server databases.
• Devices
  Monitor the devices used by Adaptive Server.
• Engines
  Monitor Adaptive Server engines.
• Extended Stored Procedures
  Create, delete, modify, and administer extended stored procedures using the Administration Console of Sybase Control Center.
• Functions
  Manage scalar and SQLJ functions using the Administration Console of Sybase Control Center.
• Networks
  Mangage remote servers.
• Performance
  Use the Administration Console to manage thread pools, execution classes, and engine groups.
• Procedures
  Manage stored and SQLJ procedures using the Administration Console of Sybase Control Center.
• Processes
  Monitor Adaptive Server processes.
• Replication Agents
  Monitor RepAgent threads for replicate databases on the selected Adaptive Server.
• Rules
  Manage rules using the Administration Console of Sybase Control Center.
• 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 Values
  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 identify if your system is running as efficiently as possible.
• SQL Activity
  Monitor SQL queries on Adaptive Server.
• Tables
  Manage tables used by Adaptive Server databases.
• Threads
  Monitor Adaptive Server threads.
• Transactions
  Monitor active Adaptive Server 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 views using the Administration Console of Sybase Control Center.