Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2007
    Posts
    167

    Unanswered: Installing.... Historical Server

    Is the Historical Server (component of Monitor Server) a part of the Sybase ASE media / install package? Or is it a completely separate install?

    For example, when you install Monitor Server, it is part of the Sybase ASE install. When I walked through the install, there doesn't seem to be any option to install Historical Server as well.

    What are your thoughts? Has anyone performed a Historical Server install? If so, is it a completely independant install? Separate from the Sybase ASE install?

    Thank you.

  2. #2
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97
    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.

    Regards,
    Mariano Corral

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    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.

  4. #4
    Join Date
    Mar 2007
    Posts
    167

    Historical Server -- Manual Configuration...?

    corral,

    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

  5. #5
    Join Date
    Mar 2007
    Posts
    167

    MDA vs. Historical Server / Monitor Server

    willy_and_the_ci,

    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.)?

    Thank you.
    Last edited by ftmjr; 07-30-07 at 03:06.

  6. #6
    Join Date
    Mar 2007
    Posts
    167

    Installshield...

    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?

    Many thanks for your help.

  7. #7
    Join Date
    Aug 2002
    Location
    Madrid, Spain
    Posts
    97

    To start Historical Server, first bring Monitor Server in. Then, you may start Historical with a RUN file like this:

    #!/usr/bin/sh

    $SYBASE/$SYBASE_ASE/bin/histserver \
    -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.


    #!/usr/bin/ksh
    # Descripcion: Arranca una recording session de HMS, con dos views

    RUTAHMS=$SYBASE/admin/HMS/EUROPA
    LOG=$RUTAHMS/hmsrecord2.log
    MUESTREO=600 # Segundos entre dos muestras recogidas
    HORA="22:30" # Hora a la que termina la recording session
    HASTA="2007/03/24 08:30"

    HOY=`date +"%Y/%m/%d"`
    DESDE=${HOY}`date +" %H:%M`
    # HASTA="${HOY} ${HORA}"

    $SYBASE/$SYBASE_OCS/bin/isql -U sa -S MXG2000_PR01_HMS -J iso_1 -w 100 \
    -P xxxxx <<FIN1
    hs_create_recording_session MXG2000_PR01_MS, $MUESTREO, $RUTAHMS,
    "$DESDE", "$HASTA", public, continue, sybase_script
    go

    hs_create_view EAdisco,
    "Device Name", "Value for Sample",
    "Device Reads", "Rate for Sample",
    "Device Writes", "Rate for Sample"
    go

    hs_create_view EAtabla,
    "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"
    go

    hs_create_filter EAtabla, "Page I/O",
    "Value for Sample", range, low, 50000
    go

    hs_initiate_recording
    go
    FIN1

    echo "\nCreada una recording session hasta $HASTA. Muestras cada $MUESTREO segundos."
    exit 0



    Regards,
    Mariano Corral

  8. #8
    Join Date
    Mar 2007
    Posts
    167

    Thank you! :)

    Dear Mariano Corral,

    Thank you so much. I was able to successfully get Historical Server running. I'm truly grateful for your help.

    Many thanks

    P.S. I'm now working on trying to understand recording sessions by following your example. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •