Historical Server comes with the ASE package, as Monitor Server.
asecfg and other configuration utilities do not provide assistance
for Historical Server, but to bring it up you only need to insert its
info in interfaces and build a RUN_histserver file. So, doing this
manually is easy.
The hard job comes later, when you start designing recording views
and building scripts to accumulate historical data in tables.
That's incorrect! Historical Server actually feeds off Monitor Server and simply dumps the output.
Historical Server recording sessions are very easy to build, but to be honest is really an outdated tool in Sybase.
Depending on what you are trying to monitor, the MDA tables are far more effective in ASE 12.5 and even better in 15.0. The beauty is that MDA values can be extracted and stored back into an database repository and reports generated.
Go to Rob Verschoor's website and you will find many examples.
Thank you for your response and for the information you provided. How do I manually create the Run_histserver file? Do I use the "startserver" utility to start Historical Server? Will the Historical server run / live on the dataserver that it's monitoring? Or will it live on a remote monitoring server?
To my understanding, Sybase Central also has plug-ins that can be used to display the data outputed by Monitor Server. Is this correct? Is a GUI a better way to go? Will using the Sybase Central GUI make it easier to setup, manage and display?
Thank you for your response and information you provided. Do you think it is discouraged to use Historical Server / Monitor Server? Will Sybase support for it eventually be phased out and MDA tables will be the preferred way to monitor? What are your thoughts?
If we use MDA table, is there a risk of master database space issues? Are there performance concerns for monitoring busy systems? Are there graphical ways to manage and view MDA output (i.e. graphs, charts, etc.)?
I'm really racking my head against the wall over here. For the life of me I can't figure out how to install Historical Server.
I was thinking it was an option I could select during the Installshield for ASE, but do not see the option for Historical server. The Installshied has options for ASE, Backup Server, XP Server and Monitor Server... but does not have any for Historical Server.
How do I install Historical Server? Do I use the same Installsheild that is used for ASE? Or is it a completely seperate install program?
To start Historical Server, first bring Monitor Server in. Then, you may start Historical with a RUN file like this:
-S MXG2000_PR02_HMS \
-D $SYBASE/admin/HMS/LATAM \
-l $SYBASE/admin/install/MXG2000_PR02_HMS.log \
-n 6 \
-U superusr -P superpwd # User and pwd for the Historical superuser
To start some recording sessions with their views, you can run something like this, where isql uses the Historical Server with ASE sa login and ASE sa password, not the superuser shown before. Many of the items with "Value for Sample" had better used "Rate for Sample" instead.
# Descripcion: Arranca una recording session de HMS, con dos views
MUESTREO=600 # Segundos entre dos muestras recogidas
HORA="22:30" # Hora a la que termina la recording session
"Device Name", "Value for Sample",
"Device Reads", "Rate for Sample",
"Device Writes", "Rate for Sample"
"Database ID", "Value for Sample",
"Database Name", "Value for Sample",
"Object ID", "Value for Sample",
"Object Name", "Value for Sample",
"Page I/O", "Value for Sample",
"Logical Page Reads", "Value for Sample",
"Index Logical Reads", "Value for Sample",
"Physical Page Reads", "Value for Sample",
"Index Physical Reads", "Value for Sample",
"Page Writes", "Value for Sample",
"Locks Granted After Wait", "Value for Sample",
"Locks Granted Immediately", "Value for Sample",
"Locks Not Granted", "Value for Sample"
hs_create_filter EAtabla, "Page I/O",
"Value for Sample", range, low, 50000
echo "\nCreada una recording session hasta $HASTA. Muestras cada $MUESTREO segundos."