dvdstore / ds3 Goto Github PK

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 :

Thanks & Regards
Ajay Vaaka

Data load giving me following error

Environment :
ESXi : 6.7
Win : 2019
SQL : 2019

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

Thanks & Regards
Ajay Vaaka

Hi Team,

I'm able to run ds3 on single SQL instance , i have issue with running on multiple SQL targets . Can i get pre-requirement setup for multiple SQL server run please.

Command :
.\sqlserverds3\ds3sqlserverdriver.exe --target=10.1.11.22;10.1.11.21 --log_timestamp=LOCAL --n_threads=8 --ramp_rate=10 --run_time=5 --db_size=10MB --warmup_time=0 --think_time=0.085 --n_searches=3 --search_batch_size=5 --n_line_items=5 --windows_perf_host=10.1.11.22;10.1.11.21 --detailed_view=Y --out_filename=testresults1.txt

issue :

able to communicate with one server (localhost) , not with another SQL server.

Thanks & Regards
Ajay Vaaka

Hi, I keep getting this error when trying to run the db setup scripts.

I'm installing on Windows and followed all the steps - unzipped in C, created C:sql\dbfiles, ran Install_DVDStore.pl and CreateConfigFile.pl.

Thanks for creating this. Any help is much appreciated.

If it is possible, it would be appreciated if the DS3 SQL drivers could be recompiled in 64 bit, for compatibility with Windows Server 2016 Nano installs.

I've installed ds2 on a AWS AMI EC2 instance to host the server with a MySQL database. I've successfully loaded the data into the database. For the client, I've launched another Linux Centos EC2 instance in AWS and successfully confirmed that I can access the mysql database from the server machine.

To compile the .exe file, I've installed Mono and have successfully compiled the program. However, when running the program, I am getting the following error:

[root@ip-172-31-36-226 drivers]# mono ds2mysqldriver.exe --target=172.31.46.171
Total number of Threads to be Spawned across multiple servers are n_threads: 1
target= 172.31.46.171 n_threads= 1 ramp_rate= 10 run_time= 0 db_size= 10MB warmup_time= 1 think_time= 0
pct_newcustomers= 20 n_searches= 3 search_batch_size= 5 n_line_items= 5 virt_dir= ds2 page_type= php windows_perf_host= detailed_view= N linux_perf_host=

Using WIN32 QueryPerformanceCounters for measuring response time

Performance Counter Category Test and Counters MaxRT and OPM created

Unhandled Exception:
System.TypeLoadException: Could not load type of field 'ds2xdriver.ds2Interface:objConn' (1) due to: Could not load file or assembly 'MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. assembly:MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d type: member:(null) signature:
at ds2xdriver.Controller..ctor (System.String[] argarray) [0x00f1d] in :0
at ds2xdriver.Controller.Main (System.String[] args) [0x00001] in :0
[ERROR] FATAL UNHANDLED EXCEPTION: System.TypeLoadException: Could not load type of field 'ds2xdriver.ds2Interface:objConn' (1) due to: Could not load file or assembly 'MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' or one of its dependencies. assembly:MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d type: member:(null) signature:
at ds2xdriver.Controller..ctor (System.String[] argarray) [0x00f1d] in :0
at ds2xdriver.Controller.Main (System.String[] args) [0x00001] in :0

I cannot understand what is preventing the program from running because I was able to access the MySQL database from the server using the -h parameter. Any help is appreciated in effort to resolve this.
Thanks!

Hi,
I generated configfile via CreateConfigFile.pl. Creation was successful (even though the output message contains ds2 instead of ds3) but when I run ds3webdriver.exe --config_file=DriverConfig.txt, I get the following error message.

Incorrect format in parameter: --config_file=DriverConfig.txt

Generated config file DriverConfig.txt

I'm attempting to create a database target of 1024GB and the creation process fails immediately when attempting to create the customer CSV files. I drop the size below a terabyte and it works as expected.

The generated (and default) Create login scripts reference ds2user and ds3user see below. This causes errors during execution that have to be manually corrected.

--Added by GSK Create Login and then add users and their specific roles for database
USE [master]
GO
IF NOT EXISTS(SELECT name FROM sys.server_principals WHERE name = 'ds2user')
BEGIN
    CREATE LOGIN [ds2user] WITH PASSWORD=N'',
    DEFAULT_DATABASE=[master],
    DEFAULT_LANGUAGE=[us_english],
    CHECK_EXPIRATION=OFF,
    CHECK_POLICY=OFF


    EXEC master..sp_addsrvrolemember @loginame = N'ds2user', @rolename = N'sysadmin'

    USE [DS3]
    CREATE USER [ds3DS3user] FOR LOGIN [ds3user]

    USE [DS3]
    EXEC sp_addrolemember N'db_owner', N'ds3DS3user'