Adaptive Server Enterprise Monitor Historical Server User’s Guide describes how to use Sybase Adaptive Server Enterprise Monitor Historical Server version 12.5 (Historical Server). Historical Server is a Sybase Open Server™ application that obtains performance statistics on Sybase SQL Server™ version 11.0 and Adaptive Server Enterprise version 11.5 and later.
This book is for people responsible for:
Configuring and managing Historical Server
Using Historical Server to monitor Adaptive Server performance
This book contains the following chapters:
Chapter 1, “Introduction” provides an overview of Adaptive Server Enterprise Monitor and presents some basic Historical Server concepts.
Chapter 2, “Configuring Historical Server” describes how to complete an initial Historical Server configuration or change a configuration, for both UNIX and Windows NT platforms.
Chapter 3, “Starting and Stopping Historical Server” describes how to start and stop Historical Server on both UNIX and Windows NT platforms.
Chapter 4, “Command Reference” describes the isql command interface to Historical Server.
Chapter 5, “Data Files” describes the files that Historical Server creates and how to access the data in them, including how to use the bcp utility to load the data into Adaptive Server tables.
Appendix A, “Data Items” provides descriptions of the data items available through Historical Server.
Appendix B, “Specifications for Defining Recording Session Views” describes valid combinations of data item names and statistic types for defining recording session views.
Appendix C, “Specifications for Defining Playback Views” describes valid combinations of data item names and statistic types for defining playback session views.
Appendix D, “Examples of Recording Session Views” provides examples of recording session views.
Use the following books for more information about Adaptive Server Enterprise Monitor:
Sybase Adaptive Server Enterprise Monitor Release Bulletin contains release notes and platform-specific information about all Adaptive Server Monitor components.
Sybase Adaptive Server Enterprise Monitor Server User’s Guide describes how to configure and manage Monitor Server.
Sybase Adaptive Server Enterprise Monitor Client Library Programmer’s Guide describes how to access and use Monitor Client Library. The library provides a programming interface to the performance data gathered by Monitor Server. It also provides a programming interface for recording and playing back performance data using Historical Server.
Use the following books for more information about Adaptive Server configuration and tuning:
Open Client/ServerTM Configuration Guide for UNIX and Open Client/Server Configuration Guide for Desktop Platforms describe the utilities that enable client/server connections, such as dsedit.
Adaptive Server Enterprise Utility Programs is a guide to Adaptive Server utilities, such as isql.
Adaptive Server Enterprise System Administration Guide contains information on tuning and configuring Adaptive Server.
Adaptive Server Enterprise Performance and Tuning Guide documents Adaptive Server performance analysis and optimizing.
Use the Sybase Technical Library CD and the Technical Library Product Manuals Web site to learn more about your product:
Technical Library CD contains product manuals and is included with your software. The DynaText browser (downloadable from Product Manuals) allows you to access technical information about your product in an easy-to-use format.
Refer to the Technical Library Installation Guide in your documentation package for instructions on installing and starting the Technical Library.
Technical Library Product Manuals Web site is an HTML version of the Technical Library CD that you can access using a standard Web browser. In addition to product manuals, you will find links to the Technical Documents Web site (formerly known as Tech Info Library), the Solved Cases page, and Sybase/Powersoft newsgroups.
To access the Technical Library Product Manuals Web site, go to Product Manuals.
Technical documentation at the Sybase Web site is updated frequently.
For the latest information on product certifications
Point your Web browser to Technical Documents.
Select Products from the navigation bar on the left.
Select a product name from the product list.
Select the Certification Report filter, specify a time frame, and click Go.
Click a Certification Report title to display the report.
For the latest information on EBFs and Updates
Point your Web browser to Technical Documents.
Select EBFs/Updates. Enter user name and password information, if prompted (for existing Web accounts) or create a new account (a free service).
Specify a time frame and click Go.
Select a product.
Click an EBF/Update title to display the report.
To create a personalized view of the Sybase Web
site (including support pages)
Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.
Point your Web browser to Technical Documents
Click MySybase and create a MySybase profile.
The following table describes the style conventions used in this manual.
Description |
Examples |
|---|---|
Command names, command parameters, and other keywords appear in the text in Helvetica typeface. |
The -S parameter is required. |
Variables, file names, path names, and Adaptive Server table names appear in the text in italic typeface. |
-Uusername |
User input
appears in |
isql -Usybase -Psa -Sserver1 |
Computer
output, such as error messages and command output, appears in |
Unable to attach with shared memory. |
Brackets indicate that the enclosed item is optional. Do not type the brackets. |
[no_wait] |
Curly braces indicate that you must choose at least one of the enclosed options. Do not type the braces. |
{0,1} |
Ellipses indicate that you may repeat the preceding item multiple times in the command. Do not include ellipses in your command. |
[, dataItemName, dataItemStat]. . . |
Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you cannot resolve a problem using the manuals or online help, please have the designated person contact Sybase Technical Support or the Sybase subsidiary in your area.
