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 '12 at 03:06 PM in Default

enjoySQL gravatar image

30 2 2 3

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 '12 at 04:21 PM enjoySQL
(comments are locked)
10|1200 characters needed characters left

3 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 '12 at 08:42 AM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

+1 for SQLQueryStress... Love this simple but effective tool!
Aug 30 '12 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 '12 at 03:21 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 19 21 74

I can't think of any good tools for capacity planning, but SQL Monitor is very useful for performance analysis.
Aug 29 '12 at 04:35 PM TimothyAWiseman
Idera within its SQLdm app has cap management.
Aug 29 '12 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 '12 at 04:52 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
91k 19 21 74

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Aug 29 '12 at 03:06 PM

Seen: 1845 times

Last Updated: Aug 30 '12 at 10:18 AM