1. Ms Sql Server Stress Test Tool
2. Cached
3. Stress Testing SQL Server – SQLServerCentral
4. See Full List On Sqlservercentral.com

• While there are lots of components to consider for SQL Server performance testing, the right SQL performance tool can help you streamline the process and boost productivity. SolarWinds DPA enables you to hit the ground running when it comes to stress testing and is an ideal tool for businesses looking for a combination of user-friendliness.
• Solution Yes, the SQLQueryStress tool provided by Adam Machanic can be used to apply additional stress when testing your stored procedures. This tool can also be used to apply a dataset as random parameter values when testing your stored procedures.

The Microsoft SQL Server 2000 Resource Kit includes a variety of utilities that you may find useful. Some of the key ones include:

·Administrative Stored Procedures: This is a series of stored procedures you can run to help identify non-standard SQL Server settings. For example:

Ms Sql Server Stress Test Tool

oTo check server configuration settings for potential improvements

If it’s the first time we run this tool against SQL Server, we ought to create some test databases with different numbers of warehouses. Steps to create a test database. Let’s first review how to create a test database to use as a target for HammerDb. Here is the official answer from the consume.exe developer at Microsoft. There were some design changes in consume.exe after W2k3. In W2k8 and R2, it is always recommended to run consume.exe through Loadgen tool as Loadgen would dynamically monitor and adjust system load level as needed.

oTo check database configuration settings for potential improvements

oTo check for blocking and blocked processes

oTo identify specific table settings, such as the use of pinned tables

What may be the most interesting aspect about these stored procedures is to dive into the Transact-SQL behind the stored procedures to see how they run. The can tell you a lot about what makes SQL Server tick.

·Analysis Services Thin Web Client: If you use Analysis Services, you may find the code behind this client interesting. You can view cube information directly from IE.

·BII: This tool is like BCP, but instead of importing or exporting text, BII is designed to import bulk image data directly into image columns. While I don’t normally recommend storing images in SQL Server because of performance, this is an interesting tool.

·Database Generator: Used to create test data for a test database.

·Database Hammer: This VB-based tool can be used to generate loads against your server for stress testing.

·Database Management: This includes tools and samples (good learning tool) to use web pages or a customized MMC console to view and manage SQL Server.

Cached

·Digital Dashboard: If you want to learn how to write your own custom administrative tool to monitor SQL Server using Microsoft’s Digital Dashboard technology, then you may find this interesting.

Stress Testing SQL Server – SQLServerCentral

·Simple Log Shipper: A tool that helps you set up log shipping for SQL Server 2000, including both SQL Server 2000 Standard and Enterprise. This freebie is not as robust as the version includes with SQL Server 2000 Enterprise, but at least it is free. Personally, I still prefer to write my own log shipping code.

See Full List On Sqlservercentral.com

[2000] Added 1-2-2003