Printer Friendly
The Free Library
19,604,538 articles and books
Member login
User name  
Password 
 
Join us Forgot password?

BAPCo Debuts Benchmarking Software Which Measures the Performance of Database Servers.


SANTA CLARA Santa Clara, city, Cuba
Santa Clara (sän`tä klä`rä), city (1994 est. pop. 217,000), capital of Villa Clara prov., central Cuba.
, Calif.--(BUSINESS WIRE)--Dec. 14, 1998--The Business Applications Performance Corporation (BAPCo), a non-profit consortium of leading computer industry publications, independent testing labs, PC hardware manufacturers, software publishers, and semiconductor manufacturers today announces SYSmark(R) for Database Servers, "SYSmark(R) DB," the industry's preeminent pre·em·i·nent or pre-em·i·nent  
adj.
Superior to or notable above all others; outstanding. See Synonyms at dominant, noted.



[Middle English, from Latin prae
 server benchmark is designed to measure the performance of a multi-user computer operating as a database server in an open Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System.  6.5 client-server environment.

The first release of the SYSmark DB workload is driven from client personal computers, running Windows NT (Windows New Technology) A 32-bit operating system from Microsoft for Intel x86 CPUs. NT is the core technology in Windows 2000 and Windows XP (see Windows). Available in separate client and server versions, it includes built-in networking and preemptive multitasking. , and intended for the low to medium server market. The BAPCo committee is currently working on a future release, for the complete server line from low-end to high-end servers.

This SYSmark DB benchmark allows a fair comparison of database servers running Microsoft Windows See Windows.

(operating system) Microsoft Windows - Microsoft's proprietary window system and user interface software released in 1985 to run on top of MS-DOS. Widely criticised for being too slow (hence "Windoze", "Microsloth Windows") on the machines available then.
 NT with Microsoft SQL SQL
 in full Structured Query Language.

Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results.
 6.5 Server as the database. The workload is driven from client personal computers and executed on servers of various architectures. The Clients are connected to the Server Under Test (SUT SUT Sport Utility Truck
SUT System Under Test
SUT Suranaree University of Technology (Thailand)
SUT Sharif University of Technology
SUT Swinburne University of Technology (Australia) 
) via network connections. The benchmark uses the Open Database Connectivity See ODBC.

(standard, database) Open DataBase Connectivity - (ODBC) A standard for accessing different database systems. There are interfaces for Visual Basic, Visual C++, SQL and the ODBC driver pack contains drivers for the Access, Paradox, dBase, Text, Excel and Btrieve
 (ODBC (Open DataBase Connectivity) A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. ) protocol to communicate to the database. ODBC provides easy portability to other O/Ss and databases that support the ODBC protocol.

The client workstations must be capable of running 32-bit Windows applications A program that is written to run under Microsoft's Windows operating system. Such applications typically run under all 32-bit versions of Windows, but earlier applications might also run under the 16-bit versions (Windows 3.x) as well. See Windows.  and the application environment of the client workstations must provide support for ODBC drivers for the database management system installed on the tested server. The communication protocol must also provide support for the ODBC connections as well.

Key SYSmark DB "Ease-of-use" features include the following:

-0-
--   fast ramp-up time;
--   help facilities for running, tuning and evaluating the benchmark
     program;
--   a menu-structure GUI interface with on-line help;
--   dynamic problem detection;
--   no audit requirement except for BAPCo's review process; and
--   low measurement and reporting costs compared to other database
     benchmarks.
--   Microsoft SQL 7.0 compliant.

     The SYSmark DB can be purchased in either the Standard or
Advanced versions. The Standard version is designed to provide a
Graphical User Interface (GUI) to a set of database benchmarks, which
includes:

-0-


-- Database layout, build, and drop functionality. The database size

is configurable and the build process has exceeded 4 GB/hour on a

high-end system. -- Creation of Run Scripts which define batches of benchmark runs

which can be submitted to run with a few mouse clicks. These are

described as a combination of Workloads (Transaction Mix/Database

combinations), Number of Generators, Run-time, etc. -- Runs benchmarks, collect results, and present them as a

collection of graphs/tables. -- Automated Full Disclosure Report (FDR) process. This includes

retrieval of HW and SW configuration information, run rule

validity checking Routines in a data entry program that test the input for correct and reasonable conditions, such as account numbers falling within a range, numeric data being all digits, dates having a valid month, day and year, etc. , and generation of a floppy for submission of

results. -- Automatic load distribution (proportional to the Client systems'

capacities). -- Automatic Deadlock See deadly embrace.

(parallel, programming) deadlock - A situation where two or more processes are unable to proceed because each is waiting for one of the others to do something.
 recovery. Benchmark Abort capability. Built-in

crash recovery mechanism.

The Advanced version is focused on providing "what if" capabilities and adds:

-- Integrated performance-monitoring tools. This automates the

collection process during complex Run Scripts. -- Transaction mix editor:

View, create, compile, or customize transaction scripts.

Several execution orders (RandomOrder_FixedTime,

RandomOrder_FixedLoad, FixedOrder_FixedLoad).

Support for transaction weights and think times. -- Configuration editors:

Customizable Database definitions. Change the number or

characteristics of tables, indexes, or fields.

Alter the scripts used to determine how the tables and their

corresponding fields are filled. -- Supports user extensions to the benchmarking environment:

Integration of user defined Any format, layout, structure or language that is developed by the user.  monitoring tools.

Addition of user defined commands to the scripting language A high-level programming, or command, language that is interpreted (translated on the fly) rather than compiled ahead of time. A scripting, or script, language may be a general-purpose programming language or it may be limited to specific functions used to augment the running of an . -- Capacity Planning Determining the required future configuration of hardware and software for a network, datacenter or Web site. There are numerous capacity planning tools on the market used to monitor and analyze the performance of the current hardware and software.  Tool

SYSmark DB can be used by:

-- Information technologists and end users who make purchasing

decisions for low to medium servers running Windows NT. -- Industry publications and testing labs in need of a robust tool

for evaluating server performance. -- Hardware developers who need to analyze and tune products under

development.
-0-

     "Today, BAPCo breaks new ground again by introducing SYSmark DB,
a true SQL client-server database benchmark that is a cost effective,
easy to use, SQL 7.0 compliant rich tool," said John Florkowski,
BAPCo's president. "We expect demand to be high, since this is the
first easy-to-use database server benchmark with an automated Full
Disclosure Report feature."
     The Standard version SYSmark for Database Servers, Version 1, is
available for $995 on CD-ROM. The Advanced version is also available
on CD-ROM for $4,995. Copies of these products may also be downloaded
from BAPCo's web-site. Video training courses are available for both
versions of the benchmark which were developed and are supported by
the current BAPCo membership which includes: Adaptec, Amdahl
Corporation, Compaq, Dell, Federal Computer Week, Gateway2000,
Hewlett-Packard, IBM, Intel, InfoWorld, Lotus, Microsoft, Motorola,
NEC, Digital Equipment Corp., and Unisys.
     SYSmark DB and other BAPCo benchmark products can be ordered by
calling 800/321-0457. For more information, contact BAPCo, 2200
Mission College Blvd., RN2-02, Santa Clara, CA 95052; phone:
408/988-7654; fax: 408/765-4920; Internet: http://www.bapco.com.

     Note to Editors: BAPCo and SYSmark are trademarks, or registered
trademarks of The Business Applications Performance Corporation. All
other names mentioned are trademarks, or registered trademarks of
their respective companies.


COPYRIGHT 1998 Business Wire
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 1998, Gale Group. All rights reserved. Gale Group is a Thomson Corporation Company.

 Reader Opinion

Title:

Comment:



 

Article Details
Printer friendly Cite/link Email Feedback
Publication:Business Wire
Date:Dec 15, 1998
Words:823
Previous Article:Correctional Properties Trust to Release Fourth Quarter Earnings.
Next Article:Bonded Motors Expects Earnings Shortfall; Weak 4th Quarter Sales; Higher Than Expected Returns.
Topics:



Related Articles
Benchmarking 101.
INDUSTRY LEADERS DEBUT SUPPORT INDUSTRY BENCHMARK DATABASE.
BENCHMARKING PUBLIC LIBRARIES: COMPARISONS IN CONTEXT.
Managing by Measuring, How to Improve Your Organization's Performance Through Effective Benchmarking.
2001 ANNUAL FINANCIAL RATIOS.
Building the first industry-standard storage benchmark.
SQL Optimizer improves DB2 UDB performance.
Boosting business performance through benchmarking: benchmarking both external and internal data and using business performance management (BPM)...
A programme for benchmarking.
Cartesis.

Terms of use | Copyright © 2012 Farlex, Inc. | Feedback | For webmasters | Submit articles