CONTENTS Title Page Copyright Page Preface 1 Overview 1.1 Performance Solution Products 1.2 The Performance Data Collector 1.2.1 Data Collector Support for the Performance Advisor 1.2.2 Data Collector Support for the Capacity Planner 1.2.3 Features of the Data Collector and Utilities 1.3 The Performance Advisor 1.3.1 Features of the Performance Advisor 2 Controlling Data Collection 2.1 An Overview of Data Collection 2.1.1 Required Privileges 2.1.2 Nonpaged Pool Requirements 2.2 How Data Collection Is Controlled 2.2.1 Options for Collecting Data 2.2.2 Selecting Data by Classes 2.3 The Primary Data Collector 2.3.1 The Schedule File and Collection Definitions 2.3.1.1 When Changes Take Affect 2.3.2 Examining the Schedule File 2.3.3 How Primary Data Collection Is Synchronized in a Cluster System 2.4 Alternate Data Collectors 2.5 Supporting Performance Advisor RealTime Data Collectors 2.5.1 Setting Up the DECnet Phase IV Object and a User Account 2.5.2 Setting Up Proxy Access 2.5.3 Setting Up the DECnet Phase V Session Control 2.6 Customizing Collection Definitions 2.6.1 Changing Weekly Collection Schedule 2.6.2 Changing the Database Directory 2.6.3 Adding, Changing, and Reordering Node Names in a Collection Definition 2.6.4 Changing the Beginning and Ending Dates for Data Collection 2.6.5 Creating Your Own Collection Definitions 2.6.6 Creating a New Schedule File 2.7 Starting the Data Collection Processes 2.7.1 Monitoring Data Collection 2.7.1.1 Checking the Data Collection Status 2.7.1.2 Checking the Data Collection Error Log 2.7.2 Stopping the Data Collection Processes 2.8 Using the Database Directory 2.8.1 Using the Daily Data Files (CPD) 2.8.2 Storing and Deleting Daily Data Files 2.9 The Event Monitor Data Collector 2.9.1 Data Collected by the Event Monitor 2.9.2 Event Monitor Data Collection Batch Jobs 2.9.3 Event Monitor Interfaces 3 Characterizing Workloads 3.1 About Workloads 3.2 Creating User-Group Workload Definitions 3.3 Defining User-Group Families 3.4 Creating Transaction Workload Definitions 3.5 Defining Transaction Families 3.6 Using Workload Families with Performance Solution Data 3.6.1 Archiving 3.6.2 Graphing 3.6.3 Performance Evaluation - Process Statistics 3.6.4 Dumping Archived Data 3.6.5 DECwindows Interface 3.6.6 Capacity Planner 4 History Files and Archiving 4.1 Setting Up a History File Reduction Scheme 4.2 Archiving Performance Solution Data 4.3 Using History Files 5 Dump Reports 5.1 Reports for Selected Data or Time Periods 5.1.1 Subsets of Data 5.1.2 Time Periods 5.2 Interpreting the Dump Reports 5.2.1 Dump Report: Heading 5.2.2 Dump Report: Metrics Record 5.2.3 Dump Report: Parameter Record 5.2.4 Dump Report: Rules Record 5.2.5 Dump Report: Process Record 5.2.6 Dump Report: Disk Records 5.2.7 Dump Report: Tape Record 5.2.8 Dump Report: Communications Record 5.2.9 Dump Report: Configuration and SCS Record 5.2.10 Dump Report: CPU Record 5.2.11 Dump Report: Hot Files Record 5.2.12 Dump Report: Data Cells Record 5.2.13 Sampling Techniques of Dump Report Items 6 Analyzing the System Program Counter 6.1 Introduction 6.2 Using the System PC Analysis Facility 6.2.1 Collecting PC Statistics for a Single Process 6.2.2 Generating Reports from a System-Wide PC Log File 6.2.3 Investigating System CPU Time 6.3 Description of the Program Counter Analysis Report 6.3.1 General Information 6.3.1.1 Header Information 6.3.1.2 Processes at Start Time 6.3.1.3 Drivers at Start Time 6.3.2 Executive Layout 6.3.3 Processor Usage by Process 6.3.4 Processor Utilization by IPL 6.3.5 Processor Usage by IPL for Interrupt Stack 6.3.6 Processor Usage by IPL for a Specific Process 6.3.7 PC Samples by System Image 6.3.8 PC Samples by System Module 7 Displaying File Activity 7.1 Introduction 7.2 Invoking the File Activity Display 7.3 File Activity Interactive Commands 8 Disk Space Analysis 8.1 Introduction 8.2 Using the Disk Space Analysis Utility 8.3 Investigating Disk Fragmentation 8.4 Determining if Disk Use Corresponds to Initialization 9 The Event Trace Facility 9.1 Introduction 9.2 Using the Event Trace Facility 10 Programming with the Event Trace Facility 10.1 Introduction to the Event Trace Facility 10.1.1 Who Can Use the Event Trace Facility? 10.2 Description of Event Trace Facility Services 10.2.1 Creation of the Event Trace Facility 10.2.2 Trace Point Definition (PSDC$DEFTP) 10.2.3 Activating Trace Points (PSDC$ACTTP) 10.2.4 Flow of Control at a Trace Point 10.2.5 Deactivation of Trace Points (PSDC$DEACTP) 10.2.6 Deleting the Event Trace Facility (PSDC$DELETF) 10.3 Guidelines for Writing an Event Trace Program 10.3.1 User-Written Routine Guidelines 10.3.1.1 Trace Record Allocation 10.3.1.2 ETF Timestamps 10.3.2 The User Mode Trace Program 10.3.3 Side Effects of Using the Event Trace Facility 10.3.4 Assembling and Linking a Program PSDC$CRETF PSDC$DEFTP PSDC$ACTTP PSDC$DEACTP PSDC$DELETF PSDC$GETNEB PSDC$RELERB 11 Data Collector and Utilities Commands ADVISE ARCHIVE ADVISE COLLECT ADVISE COLLECT ADD ADVISE COLLECT DELETE ADVISE COLLECT DISPLAY FILES ADVISE COLLECT MODIFY ADVISE COLLECT REPORT DISK_SPACE ADVISE COLLECT REPORT DUMP_keyword ADVISE COLLECT REPORT SYSTEM_PC ADVISE COLLECT SHOW ADVISE COLLECT START ADVISE COLLECT STOP ADVISE EDIT ADVISE COLLECT SYSTEM_PC ADVISE COLLECT/EVENT ADVISE/INTERFACE 12 Parameter Editor Commands ADVISE EDIT ADD/FAMILY ADD/HISTORY ADD/WORKLOAD DELETE/FAMILY DELETE/HISTORY DELETE/WORKLOAD EXIT MODIFY/FAMILY MODIFY/HISTORY MODIFY/WORKLOAD QUIT SET AUTO_AUGMENT SET VERSION_LIMIT SHOW/ALL SHOW/AUTO_AUGMENT SHOW/FAMILY SHOW/HISTORY SHOW/VERSION_LIMIT SHOW/WORKLOAD 13 Using the DECwindows Motif Interface 13.1 Starting the Performance Solution DECwindows Motif Interface 13.2 Controlling the Performance Solution Interface 13.2.1 Reading the Parameter File 13.2.2 Writing the Parameter File 13.2.3 Quitting the Session 13.3 Selecting Data for Viewing Dump Reports 13.4 Displaying a Dump Report 13.4.1 Filtering Process Data 13.5 Customizing 13.5.1 Customizing Data Collection 13.5.1.1 Modifying or Creating a Collection Definition 13.5.1.2 Changing Collection Definition Parameters 13.5.2 Customizing PSDC$DATABASE Definition 13.5.3 Customizing Parameters 13.5.3.1 Starting Parameter Editing 13.5.4 Workload Definitions 13.5.4.1 Creating a Workload Definition 13.5.4.2 Deleting a Workload Definition 13.5.4.3 Modifying Workload Definitions 13.5.5 Workload Family Definitions 13.5.5.1 Creating a Workload Family 13.5.5.2 Deleting a Workload Family 13.5.5.3 Modifying a Workload Family 13.5.6 History File Descriptors 13.5.6.1 Creating a History File Descriptor 13.5.6.2 Deleting a History File Descriptor 13.5.6.3 Modifying a History File Descriptor 13.5.7 Parameter Settings 13.6 Viewing the Main Window 13.7 Getting Help 14 Using SPM Data 14.1 Requirements and Limitations 14.2 Converting SPM Files 14.2.1 Creating a History Descriptor 14.2.2 Converting the Data A Error Messages and Recovery Procedures B Data Collector Logical Names C The Default Workload Families D SPM Data Fields Glossary