Introduction

    If you are going to use the SQLWorkloadManager for the Heaton Research Spider, you will need to create a proper database. Specifically, this database should have the SPIDER_WORKLOAD and SPIDER_HOST tables. This chapter shows how to create this database on a variety of database servers.

    Data Definition Language (DDL) scripts contain the commands necessary to create the tables needed by the spider. DDL varies greatly from database vendor to database vendor. DDL scripts are provided in this chapter for three of the major database vendors. If you wish to use the spider on a database not listed here, you will have to develop your own DDL script based on the tables needed by the spider. Usually, you can just modify one of the scripts here as a starting point.

    All of the DDL and configuration files presented in this chapter are contained on the companion download for this book.