I have uneven distribution of users across storage groups. Storage group 1 has 700 GB with 739 users and storage group 2 has 350 GB with 261 users.
Can I run multiple instances of JetstressWin.exe or JetstressCmd.exe (one instance per storage group) for database files of different sizes that I have manually prepared?
I should discourage running multiple instances of Jetstress — that can possibly lead to conflicting database performance counter names. I should encourage even distribution of load generation across storage groups.
Jetstress makes even load distribution by default. But, Jetstress accommodates the case where a user can set in the configuration file to use different numbers of IOPS for each storage group.
The following configuration has two things to note:
· Each storage group has four database files on J:\ and 2 database files on K:\ — every database file has the same size when they are prepared.
· Each storage group has IOPS bias numbers — each database transactions randomly picks a database instance (also called a storage group) based on IOPS bias. The distribution will be like 73.9% of transactions on storage group 1 and 26.1% of transactions on storage group 2.
Jetstress logs batch transactions stats at the end of a test as follows.
The following log text shows that Jetstress has run 132505 and 46791 batch transactions (74% and 26%) on storage group 1 and 2.
3/16/2007 12:39:43 PM — JetInterop batch transaction stats: 132505, and 46791.
This posting is provided “AS IS” with no warranties, and confers no rights.