Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Performance Test Tools

2 posts in General Discussion Last posting was on 2004-01-20 21:06:29.0Z
Markus Flöter Posted on 2004-01-20 17:44:36.0Z
Sender: 37f8.400d6801.1804289383@sybase.com
From: Markus Flöter
Newsgroups: ianywhere.public.general
Subject: SQL Performance Test Tools
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <400d6904.3804.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Jan 2004 09:44:36 -0800
X-Trace: forums-1-dub 1074620676 10.22.241.41 (20 Jan 2004 09:44:36 -0800)
X-Original-Trace: 20 Jan 2004 09:44:36 -0800, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2357
Article PK: 4562

Hello,

is the any 'smart and clever' sql performance testtool
available ?
I want to
- generate testdata for an 'empty' Database with, to fill
the tables with data
- send sql statements (select, insert, update, delete) to
the database simulating multi user access

Any hints for me ?


David Fishburn Posted on 2004-01-20 21:06:29.0Z
Newsgroups: ianywhere.public.general
Subject: Re: SQL Performance Test Tools
From: David Fishburn <fishburn_spam_off@ianywhere.com>
References: <400d6904.3804.846930886@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns9476A12F0A521fishburnsybasecom@10.22.241.106>
User-Agent: Xnews/06.08.25
NNTP-Posting-Host: fishburn-t30.sybase.com
X-Original-NNTP-Posting-Host: fishburn-t30.sybase.com
Date: 20 Jan 2004 13:06:29 -0800
X-Trace: forums-1-dub 1074632789 172.31.141.114 (20 Jan 2004 13:06:29 -0800)
X-Original-Trace: 20 Jan 2004 13:06:29 -0800, fishburn-t30.sybase.com
Lines: 37
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2358
Article PK: 4563

Markus Flöter wrote in news:400d6904.3804.846930886@sybase.com:

MF> is the any 'smart and clever' sql performance testtool
MF> available ?
MF> I want to
MF> - generate testdata for an 'empty' Database with, to fill
MF> the tables with data
MF> - send sql statements (select, insert, update, delete) to
MF> the database simulating multi user access

From %ASANY9%\Samples\ASA
PerformanceFetch
PerformanceInsert
PerformanceTraceTime
PerformanceTransaction

--
David Fishburn
NEW - Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList