Generating application workload N number of times at same time

Question

Generating application workload N number of times at same time

ebooklub

Hall of Fame

Points: 3905
More actions
May 11, 2018 at 8:04 am

#344551

Hi,
we have database application running on 2 SQL 2012 using 3 databases with transaction replication.
Currently CPU and I/O pretty low and wait time and duration acceptable.
Assuming we have 1000 concurrent connection from 50 different locations
I want to generate database activity for 10000, 20000 users accessing application.
Is any simple way to extract data from SQL Profiler to build connection activity ,modify data for insert operation and start 10000 times at the "same time"
Any 3-rd party utility recommended for this task?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

ebooklub Hall of Fame Points: 3905 More actions · Answer 1

found it
https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/extract-a-script-from-a-trace-sql-server-profiler?view=sql-server-2017

sharky Default port Points: 1494 More actions · Answer 2

You can use a utility like sqlstress to simulate a workload. See brent's article (https://www.brentozar.com/archive/2015/05/how-to-fake-load-tests-with-sqlquerystress/) for more thorough description. Also, rather use extended events to capture events rather than profiler/trace events that wont be supported in the future and are generally more resource intensive.