x

SQL Server stress testing tools for dbas

Looking for a tool/product DBAs must have. Any recommendation for 3rd party product for capacity planning and performance analysis?

more ▼

asked Aug 29, 2012 at 03:06 PM in Default

avatar image

enjoySQL
30 2 3 5

Thanks but the main reason we are looking for a 3rd party tool is to do workload analysis of a new product before it goes to production. We have a development environment but we don’t have many users on that environment to mimic production. So, we are looking for product that you can request it how the app is going to function with these many users and it will give you a report on how it will handle it. Hope this makes sense.

Aug 29, 2012 at 04:21 PM enjoySQL
(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

My favourites tools for stress testing are SQLIO, HammerOra and SQL Query Stress (http://sqlblog.com/blogs/adam_machanic/archive/2006/10/21/announcing-sqlquerystress-a-simple-query-load-tool.aspx)

You can get a pretty good list of these and other tools from http://sqlserverio.com/2012/08/16/free-tools-for-testing-sql-sever/

more ▼

answered Aug 30, 2012 at 08:42 AM

avatar image

Fatherjack ♦♦
43.7k 79 98 117

  • for SQLQueryStress... Love this simple but effective tool!

Aug 30, 2012 at 10:18 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

That's a pretty loaded question. Lots of people use different tools for this type of work. I work for one of the tool vendors, Red Gate Software. We make some absolute, must-have, applications. But so do many other vendors. For what you're looking for, I'd recommend our tool, SQL Monitor. It monitors your servers, including showing you all sorts of performance metrics, showing you what runs slow, when. You can see this in action against the servers that manage this web site as well as others at monitor.red-gate.com. We also publish articles about using the tool over at SQL Server Central.

more ▼

answered Aug 29, 2012 at 03:21 PM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

I can't think of any good tools for capacity planning, but SQL Monitor is very useful for performance analysis.

Aug 29, 2012 at 04:35 PM TimothyAWiseman

Idera within its SQLdm app has cap management.

Aug 29, 2012 at 04:39 PM sp_lock
(comments are locked)
10|1200 characters needed characters left

To stress test a system to determine if it can support a given load, I'd suggest using SQL SErver 2012's new tool, Distributed Replay. You can capture or create a load and then dial it up, steps at a time to place greater and greater stress on a system. You'll still need to have a monitoring tool to watch to see where you develop bottlenecks, but you can use Perfmormance Monitor and Extended Events to capture all that information. I detail how to do this in my book, SQL Server 2012 Performance Tuning.

more ▼

answered Aug 29, 2012 at 04:52 PM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left

I use the PIEngine.Net tool. You can create stress test scenarios from SQL Server trace files, or you can create a scenario from scratch. Then once the scenario is finished, you can run it manually from the UI or automatically from the command line tool. Stress test results are written as text files. In addition to that, you can capture SQL Server requests at runtime an include the captured requests in your scenario. Stress test configuration include the number of users to simulate, the number of scenario replays and the delay between requests. You can automate stress tests from multiple client machines. Check it out:

http://www.piengine.net

more ▼

answered Oct 30 at 07:50 PM

avatar image

RabihSarieddine
1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x196
x22
x3

asked: Aug 29, 2012 at 03:06 PM

Seen: 3055 times

Last Updated: Oct 30 at 07:50 PM

Copyright 2016 Redgate Software. Privacy Policy