The Leading Open Source and Commercial Software Testing Tools Website
SQL Load Test takes a SQL Profiler trace file and generates a unit test that replays the same sequence of database calls found in the trace file. The unit test is designed for Visual Studio Load Test. The code generated is easily modifiable so that data variation can be included.
There is a lot of code out there that makes load testing the application very difficult. The most common type is a client application that contains direct database calls. The application however is not structured to allow the business logic to be exercised without the GUI. Another common scenario is a legacy application written in a language such as Visual Basic 6. In cases like these, it can be difficult to load test the application without a GUI test tool, which introduces other disadvantages. GUI test tools are notoriously difficult to use, generally lead to brittle tests and also have limitations in scaling the load injectors sufficiently to exercise the servers.
This tool offers one possible alternative. You start with using the client application to generate a trace of the SQL statements which typically represent a usage scenario. You can then turn the trace into equivalent ADO.NET code program that can be used in a load test.
Tool Description
The tool generates a Visual Studio 2005/2008 Unit Test from a SQL Server Profiler trace. It extracts all the SQL statements and stored procedure calls from the trace and turns them into a single Visual Studio Unit Test, which can then be configured as a Visual Studio Load Test. The tool does not interact with the database itself when it analyzes the trace and generates the test code. It can therefore be used in “offline” scenarios.
The generated code needs to be customized to include a connection string to the database under test. That code also includes hooks to allow the user to customize the parameters that are passed to the SQL statements and stored procedures, so that variability can be introduced into the data to prevent caching from producing artificially high performance figures.
The tool is intended to be used in conjunction with a client program that runs against a database. A trace of the client’s SQL Server activity is captured using the SQL Server Profiler. This represents a test scenario, which is then processed by the tool to produce a Unit Test that replays the scenario.
Digg
Del.icio.us
Mixx
Stumble
.Net Testing Tools (129)Ajax Testing Tools (50)Ant Testing Tools (15)Benchmarking Tools (157)Browsers Based Tools (64)C/C++ (127)Cloud Based Testing Tools (15)Data comparison tools (94)Debuggers (69)Eclipse Plug-in (57)Embedded systems (16)Flash Testing Framework (26)Functional Testing Tools (68)GUI Testing Tools (59)HTML Testing Tools (46)Identity Management Testing (19)Java Testing Tools (307)Javascript (45)Link checkers (35)Linux Testing tools (22)Load Testing Tool (29)Mobile Testing Tools (1)Networking Tools (97)Oracle Database Test Tools (15)Performance Testing Tools (444)Perl Testing Tools (30)PHP Testing Tools (80)Python Testing Tools (56)Ruby Testing Tools (18)Security Systems (174)Server Management (66)Site News (2)SQL Testing Tools (144)TCl testing tools (7)Test Automation (145)Test Data Generators (29)Test Documentation Tools (23)Test Environment Management (15)Test Management (64)Unit Test Framework (51)Unix Shell (5)Visual Basic (17)Web Application Testing (28)Web Hosting Tools (108)Web Traffic Analysis (130)WinRunner Testing Tools (4)XML Testing Tools (64)
LoadJava is a command line tool that can load metadata stored in Java class files or JARs into a relational data model in SQLServer. Using the relational data model, it is possible to conduct analyses of Java code base on enterprise scale easily and efficiently.
SiteBlaster is a web site / image server load and stress testing tool. It can be used to rapidly submit requests to a site. Or, it can pause a random amount of time between submissions; approximating the behavior of a user. While the testing is being performed, the pages being tested will be displayed. When… Read More
Pylot is a free open source tool for testing performance and scalability of web services. It runs HTTP load tests, which are useful for capacity planning, benchmarking, analysis, and system tuning.
Pylot generates concurrent load (HTTP Requests), verifies server responses, and produces reports with metrics. Tests suites are executed and
Multi-Mechanize is an open source framework for web performance and load testing. It allows you to run simultaneous python scripts to generate load (synthetic transactions) against a web site or web service.
In your scripts, you have the convenience of mechanize along with the power of the full Python programming language at your disposal. You… Read More
functional and load web tester, written in Python, whose main use cases are functional and regression testing of web projects, performance testing by loading the web application and monitoring your servers, load testing to expose bugs that do not surface in cursory testing, and stress testing to overwhelm the web application resources and test the… Read More
Apache JMeter may be used to test performance both on static and dynamic resources (files, Servlets, Perl scripts, Java Objects, Data Bases and Queries, FTP Servers and more). It can be used to simulate a heavy load on a server, network or object to test its strength or to analyze overall performance under different load… Read More
The WCF Test Harness is a flexible tool that can be used to quickly test services. The utility is a windows application that uses WCF to submit requests via a given URL or proxy class. This utility is similar to other service test tools, notably WCF Load Test and SOAP UI.
UniTest is a light weight ,effective and cross browser JavaScript Unit Test framework with wide range of tests and functions.
It’s also support custom output provider to customize data view and lazy load core and test to reduce server load and run test as needed
This project contains a set of stored procedures and SQL Server 2005 Reporting Services reports for reporting on a load test result. It also contains an ASP.NET app that enables you to easily delete runs from the database and set the analysis comment on runs.
Add to favorites
