dvdstore / ds35 Goto Github PK

I'm using this tool to create huge files on remote Linux VMs.

Source VM: Windows VM
Target VMs: Linux CentOS8
Postgres installed on target VM: Postgres 12

I get the below error while running the tool ds35webdriver.exe

command C:\Users\Administrator\Downloads\ds35-main\ds35-main>drivers\ds35webdriver.exe --config_file=DriverConfig.txt

ERROR:
Error in adding RSA fingerprint for target linux host: 192.168.35.12: Cannot start process because a file name has not been provided.

I followed the instructions given. Please let me know if there is anything missing or there is an issue with the tool.

Screenshot:

Hi Team,

I'm performing SQL tuning 1st time. Please suggest for recommendations

My reference :
https://www.heraflux.com/resources/howto/sql-server-benchmarking-with-dvdstore/

Error :

Environement :

ESXi : 6.7
Win : 2016
SQL : 2019

Thanks & Regards
Ajay Vaaka

I am exploring ds35 for the first time and trying to use if for MSSQL DB(Linux) following the below steps.

(a) Install database system (OS + Oracle or SQL Server or MySQL)
(b) Download DVDStore3 to database system
(c) Ensure that Perl is setup on system
(d) Run InstallDVDStore.pl
(e) Use scripts created by InstallDVDStore.pl to create and load database
(f) On system to be used as driver, run CreateConfigFile.pl
(g) Run driver program with the parameter file created by CreateConfigFile.pl

Client: Windows 2019
DB server: MSSQL (Linux)-SLES15SP4

Following the documentation I have downloaded the ds35 to the DB server and executed the Install_DVDStore.pl

Initializing parameters...

Database Size: 14
Database size is in GB
Database Type is MSSQL
System Type for DB Server is LINUX
File Paths : /home/DS3-SQL/

Calculating Rows in tables!!
Large size database ( greater than 1 GB)
Ratio calculated : 0.14
Customer Rows: 28000000
Order Rows / month: 1400000
Product Rows: 140000

Creating CSV files....
Starting to create CSV data files....
For larger database sizes, it will take time.
Do not kill the script till execution is complete.
…..

Scripts that are created from template files have '_' 14 GB in their name.

User can edit the sql script generated for customizing sql script for more DBFiles per table and change the paths of DBFiles.

Now Run CreateConfigFile.pl perl script in ds3 folder which will generate configuration file used as input to the driver program.

Can you please help me with the sequence of scripts to be executed for the step “Use scripts created by InstallDVDStore.pl to create and load database”?

  Under ds35/sqlserverds35/build I see sqlserverds35_create_all_init_14GB.sql and ran that , DS3 database got created.
  Should it be followed by sqlserverds3_createtables.sql? , perl scripts under load looks to be meant for windows.

Apart from executing locally on the DB server how can we build and execute from the windows client as mentioned in the documentation? is it only applicable between windows client and windows DB host or can be done between windows client and Linux host acting as DB server
“The database creation has been almost completely automated in order to accomplish
the above mentioned parallelization and also to make it easier to setup and use.
It is designed to be done from a remote client or driver system that is not the
database host. It is still possible to run it all locally on the database system
if desired, although a remote driver is recommended.”