April 5, 2005 at 8:58 am
We are implementing a new Veritas cluster with iSCSI for SQL Server 2000 and are looking for a method to perform a load or stress test on our system to compare performance. I'm familiar with Database Hammer, but are there any other tools available for such a task?
Thanks.
Carpe diem!
April 5, 2005 at 9:01 am
we did some testing with SQLSTRESS when we were benchmarking our new cluster and SAN, or you can always download one of the ones from the MS website.
April 5, 2005 at 11:44 am
Take a look at Quest Benchmark for Database. You can get a 30 day trial and it's good. Told me a lot about the hardware I was implementing.
April 6, 2005 at 2:52 am
April 7, 2005 at 9:47 am
ATLDBA, as you can gather from some of the earlier replies, there are a number of tools that can perform load-stress-performance tests targeting SQL Server or other types of databases.
To add to the choices there are a number of enterprise load-stress-performance testing solutions such as IBM-Rational Robot/Test Manager (bundled in various 'suite' products), Mercury's LoadRunner, Compuware's QA-Load, Segue's SilkPerformer, and others. Most of these tools are purchased based on the communication protocol (HTTP, ODBC, DB-LIB, SQL-Net, etc.) and the number of 'virtual users' desired. However, these enterprise testing tools are fairly pricey.
Depending on your or your organization's current and future needs, this would help to decide on an appropriate testing tool. For example, if the current / future need is for only you or a few individuals to run some basic tests against the backend SQL Server DB, then the free or low-end tools would be your best option. If the need of the organization is also to test different parts of the system (such as the application server, web server) and/or the entire system as a whole -going through the entire architecture, then your organization may want to consider an an enterprise testing tool.
I have not used any of the above mentioned DB-only tools, so I cannot comment on their ability or usability. For the enterprise testing tools, some of the common advantages are: 1) they scale fairly well; 2) they can alter the requests and data used to prevent unrealistic caching; 3) they are flexible in target systems / application they can test; 4) the scripting language is robost [Sorry, I sound like a saleman, I'm not. I do system / performance testing.]
I hope some of this helps in steering you in the right direction.
- RS
For off-line questions I am available at rsternweiler@rttsweb.com
May 23, 2006 at 3:07 pm
I guess sqlstress is the piece of software by D. Kubelka. I could find the kit on the web but not the documentation explaining how to use it.
I appreciate your help
Chris
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply