Converting Your spdsperf Log into a Table

Follow these steps to convert your spdsperf log file into an SPD Server table.
  1. Execute the process_perf_log utility on your log file to create a formatted input file. The syntax for the utility is as follows:
    ../samples/process_perf_log src-path log-path dst-path
    Here are the conditions:
    src-path
    the name of the log file that is created when you run rc.perf with the -log option.
    log-path
    the path to your SPD Server Installation log directory.
    dst-path
    the full path to the location where the formatted SAS input file is to be created.
    Here’s a sample command:
    proc spdo lib=special;
         spdscmd "&site/process_perf_log &tmp/spdsperf.out &log &tmp/spdsperf.log"; 
      quit;
    
  2. Open PerfDataSample.sas in your SAS session and modify the program as follows:
    • Assign a libref to the SPD Server domain where you want the output table to be created (Special).
    • Modify the INFILE statement to specify the full path to the input file created by process_perf_log (&tmp/spdsperf.log).
  3. Run PerfdataSample.sas to create the table.
You can use PROC CONTENTS to describe the output table and PROC PRINT to see its contents. You can also use the table in SAS jobs.
Last updated: February 3, 2017