The following describes the design and management tools included with SQL Anywhere.
Sybase Central—centralized control and administration Sybase Central is an integrated database administration and development tool that provides access to database settings, properties, and utilities in a graphical user interface. Via plug-ins, Sybase Central can be used to manage SQL Anywhere Server, UltraLite, MobiLink, QAnywhere, and other Sybase products. For example, the MobiLink plug-in includes the Create Synchronization Model wizard and Model mode to assist with developing and customizing MobiLink applications.In addition to facilitating routine tasks, Sybase Central also provides performance statistics, procedure profiling, and stored procedure debugging, as well as the management of events and schedules, web services, and connection profiles. Sybase Central helps administer any tasks that are performed by sending SQL statements to the database server, or performed by SQL Anywhere utilities. See Sybase Central. A variety of Sybase Central tools are available to help you analyze and monitor the current performance of your SQL Anywhere database. These tools include procedure profiling, graphical plans, query execution, the Performance Monitor, request logging, and timing utilities. In addition, Sybase Central offers:
Application profiling using the Application Profiling wizard Use the Application Profiling wizard in Sybase Central to automatically:
Profile stored procedures, functions, triggers, and events
Receive recommendations to help improve the performance of your database application
Capture database activity while your application is running
Advanced application profiling in Application Profiling mode Improve overall performance by using the Database Tracing wizard and Application Profiling mode in Sybase Central to:
Adjust cache size and indexes based on database performance counters
Identify when deadlocks occur
Look at locking activity
Examine query plans
Trace each statement in an application for diagnosing and troubleshooting
Index selection and optimization using Index Consultant The Index Consultant analyzes workloads and provides recommendations on how to select indexes to optimize performance. The Index Consultant can be run from either Sybase Central or Interactive SQL. See Index Consultant.
Interactive SQL—SQL query editor Interactive SQL is a database utility designed to execute SQL statements and display database data. The built-in query editor and other tools, such as the graphical plan display, help you to analyze, troubleshoot, and optimize queries. See Interactive SQL.
MobiLink Monitor—synchronization monitoring The MobiLink Monitor is a graphical administration tool that provides detailed information about the performance of MobiLink synchronizations. The MobiLink Monitor collects detailed information and statistical summaries about all synchronizations that occur, including start and end times, data volume uploaded and downloaded, successful completions, conflicts, and more. See MobiLink Monitor.
Database utilities SQL Anywhere includes various utilities for performing administration tasks such as backing up a database. Utilities are useful for including in batch files for repeated use. See Database Administration Utilities.
InfoMaker InfoMaker is a personal data assistant that lets you work with data in many ways. With InfoMaker you can query your SQL Anywhere databases and create sophisticated and effective custom reports. See About InfoMaker.
PowerDesigner Physical Data Model The Physical Data Model component of Sybase PowerDesigner lets you design, generate, document, and maintain databases. Physical Data Model is available only on Windows. However, it can be used as a client of a server running on any supported operating system. See About PowerDesigner Physical Data Model.
Data Window.NET With Data Window.NET you can rapidly build and deploy enterprise-level, SQL Anywhere applications that incorporate complex business rules, and deliver sophisticated data presentation. Data Window.NET provides hundreds of built-in functions and properties, so you can experience high levels of productivity with minimal coding. Data Window.NET uses 4GL RAD technologies. See About DataWindow .NET.