http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/Bdadotnetarch081.asp There are many tools that ship with the SQL Server Resource Kit that can help you with testing your database. One of those tools, Database Hammer, is a load simulator and allows you to test your SQL Server with various loads. The Resource Kit also includes a tool for loading sample data into your system for the purpose of testing, called the Database Generator, or DBGen. To obtain either of these tools, or for more information, see the SQL Server 2000 Resource Kit. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
If you're subscribed to the MSDN then you will get it for free and for other tools may try Mercury Interactive for LoadRunner/Winrunner orhttp://www.sqa-test.com/toolpage.html for information. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
