|
Looking for a tool/product DBAs must have. Any recommendation for 3rd party product for capacity planning and performance analysis?
(comments are locked)
|
|
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/ +1 for SQLQueryStress... Love this simple but effective tool!
Aug 30 '12 at 10:18 AM
sp_lock
(comments are locked)
|
|
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. 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)
|
|
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.
(comments are locked)
|
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.