May 20, 2009 · JMeter from Apache can handle different server types. I use it for load tests against web applications, others in the team use it for DB calls. It can be configured in many ways to get the load you need. It can be run in console mode and even be clustered using different clients to minimize client overhead ( and so falsifying the results).

Has anyone come across any good tools (preferably but not necessarily FOSS) that can read a SQL Server (2005/2008) trace file and execute the commands against another database. We are attempting to perform some performance testing on our SQL servers and would like to replicate an actual load. I have come across but not yet used: JMeter; ReplayML

A surprisingly little known toolset is available for free, from Microsoft, that can cope with most SQL Server stress testing scenarios, the RML Utilities. A very brief outline of the tools: ReadTrace converts Profiler traces from .trc files to .rml (Replay Markup Language). OStress is used to replay .rml and .sql files against a server.

Jan 18, 2023 · We're moving from an EC2 hosted instance of MS SQL Server to an RDS instance, and have been tasked with "proving" that the new platform won't cause any regressions. The naive idea is to somehow replicate a day's worth of …

In SQL Server you can use the profiler or extended events to monitor for statements starting and completing, the results of that will give useful clues. If they all start together but end in sequence then most likely something is making SQL Server serialise the queries, if one starts after the previous completes then the problem is more likely ...

Aug 24, 2023 · When I execute this stored procedure with the SQL Stress tool, I get SQL Compilations/sec equal to Batch Requests/sec. Interestingly, SQL Re-Compilations/sec is zero. Both optimize for ad-hoc workloads and forced parameterization are enabled. The picture is the same even if I change my procedure to a simple SELECT 1.

Feb 17, 2015 · HammerDB is an open source database load testing and benchmarking tool for Oracle, SQL Server, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL and Redis. HammerDB is automated, multi-threaded and extensible with dynamic scripting support.

Feb 7, 2014 · I wanted to simulate Sql server deadlock and timeout. Deadlock is hard to replicate, but sql client timeout is relatively easy to reproduce. BEGIN TRANSACTION SELECT TOP 1 * FROM MyTable WITH (TABLOCKX, HOLDLOCK) ROLLBACK TRANSACTION This will lock the table and any select query will timeout.

Dec 17, 2015 · Well I thought I would pull my finger out and write myself a light weight data generator: declare @select varchar(max), @insert varchar(max), @column varchar(100), @type varchar(100), @identity bit, @db nvarchar(100) set @db = N'Orders' set @select = 'select ' set @insert = 'insert into ' + @db + ' (' declare crD cursor fast_forward for select column_name, data_type, COLUMNPROPERTY( OBJECT_ID ...

Jul 23, 2014 · I've just written something to insert 10000 rows into a table for the purposes of load testing. The data in each of the rows is the same and uninteresting. I did it like this: DECLARE @i int = 0 WHILE @i < 10000 BEGIN exec blah.CreateBasicRow ; SET @i = @i + 1 END All create basic row does is fill out the not null columns with something valid.