I need a script to stress my system

[Tison]

Does anyone have a select or proc that I can run that will push the cpu limits of my Sybase ?
(Maybe it can run against the pubs database).

 

[JMCraig]

Hmmm. Is it the CPU or the IO you want to stress? To stress the CPU, just create a loop that goes through some table a zillion times and updates a value in the table based on a calculation that has to be repeated (e.g. multiply two columns to get the value--but don't update the table with the calculated value). If you use a small table for this test, it'll end up all cached so that your IO will be limited and the stress will all be on the processor. For maximum stress on most CPU's, do floating point math.

A much more common need than would be served by the test described above is to stress the system in a way that would simulate the use of the a DB--which would generally be IO- not CPU-bound.

HTH,

J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net