This report is for system administrators and managers.

It has nothing to do with point-and-click queries.

Basic Function Testing

Basic functions have been in world-wide use for years. Problems are corrected reported.

Unattended Server Stress

CoreReader job servers are started on 6 computers.
All servers run simultaneously.
904 jobs are scheduled on each computer.
Jobs are scheduled one minute apart on each server.
Jobs run against all data sources (listed below).
Query runs vary from milliseconds to minutes.
Returns range from 800 bytes to 14 megabytes.
First jobs run at 23:00.
Last jobs run at 01:30.
Output to XML, web, and text.
Each run generates over 25,000 log records.

Embedded Database Stress

CoreReader job servers are started on 6 computers.
All servers use the same CoreReader database.
Verbose logging is on.
Statistician is on.
All servers run simultaneously.
All have jobs scheduled every 30 seconds.
All have multiple jobs scheduled simultaneously.
The test spans 20 minutes.
Jobs run against all data sources (listed below).
Each query runs from milliseconds to minutes.
Returns range from 800 bytes to 14 megabytes.
Output to XML, web, and text.

Intermittent Error Search

A single CoreReader job server is started.
Verbose logging is on.
Statistician is on.
1,428 jobs are loaded.
Jobs scheduled each minute around the clock.
Jobs run against all listed data sources.
Query times vary.
Returns range from 800 bytes to 6 megabytes.
Returns range from 6 records to 15,000 records.
Output to XML, web, and text.

Computers

        450 mhz, 128 meg RAM, 13 gig drv
        120 mhz, 64 meg RAM, 2 gig drv, 4 gig drv
        150 mhz, 64 meg RAM, 2 gig drv
        400 mhz, 128 meg RAM, 4 gig drv, 8 gig drv
        735 mhz, 128 meg RAM, 10 gig drv
        1800 mhz, 1 gig RAM, 2 40 gig drvs
        800 mhz, 128 meg RAM, 20 gig drv
        350 mhz, 64 meg RAM, 4 gig drv

Data Sources

        Access 97, 2000
        Excel
        Firebird
        FoxPro
        Ms. Sql Server Enterprise
        MySql 3.23.49
        Oracle 8i Enterprise Server
        Paradox 3.5, 7.0

Network

        1 gigabit, switched, peer

Operating Systems

        Linux, Redhat Server 6.0 (File server.)
        NT 4.0 SP6
        Windows 95
        Windows 98
        Windows 2000 Pro SP2
        Windows 2000 Server
        ( Has been run on XP, but not in this installation.)

Databases

The estimated number of databases in the environment is sixty and are spread across the network. The database size varies with the largest being nearly two thousand tables with six thousand columns.

This web site is maintained with Notepad.

Copyright 2001 - 2010 John Ragan.