Home
- Sql Query Stress Tool
- Stress Testing SQL Server – SQLServerCentral
- Microsoft Sql Server Stress Test Tool Kit
SQLStress is a tool to stress test a Microsoft SQL Server installation. Its main purpose is to find infrastructure problems within an installation. It can also be used for hardware sizing, system tuning or benchmarking. The focus is on simplicity. You should be up and running within minutes.
Prerequisite is an installed version of the .Net Framework 2.0. The tool will run on x86, x64 and Itanium. It is tested on Microsoft SQL Server 2008 and Microsoft SQL Server 2005, however most of the functionality will work on Microsoft SQL Server 2000 as well.
MultiMail 2.0 is a multi-threaded SMTP stress testing program which also doubles up as a handy tool for anti-Spam software development. It starts multiple threads, each sending a large number of mails in parallel to a specified SMTP server. MultiMail 2.0 is freeware and can be used by anyone without the author's explicit permission. Hi, I am looking for a tool that it could test the sql performance. I have 200 million records in one partitioned table. We sql sql select statement from code need to test the performance by selecting the rows from 200 millions with where clauses.
Features
- Load testing: Statement mix can be defined to remodel actual workloads
- Implements performance counters that include statement response times
- Can combine statements from different users to a distributed transaction exercising MSDTC
- Can use databases on multiple instances
- Can be used for cluster failover tests
- Can be used for mirroring failover tests
- Very efficient, can simulate thousands of virtual users
- Transaction scheduler can sustain a specified number of transactions per second
- Can be used to run stress tests against an SMTP server
The current version of the tool is free, but I reserve the right to create a commercial version with additional functionality in the future.
Sql Query Stress Tool
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:
oTo check server configuration settings for potential improvements
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.
Stress Testing SQL Server – SQLServerCentral
·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.
·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.
Microsoft Sql Server Stress Test Tool Kit
·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.
[2000] Added 1-2-2003
]]>