This is the first public release of a tool that started out as a small script for a customer project. It has been rebuilt into a WPF solution loosely following the MMVV pattern.

What is Stress Tester?

  • A distributed client - server solution to stress test SQL Server Analysis Services.
  • Tests can be created from trace files or manually in the server application.
  • Consists of two applications: A server that manages and coordinates tests and a client that can be deployed to multiple computers.
  • Outputs a flat file with the test results that can be analyzed through a supplied (very simple) Excel PowerPivot model.
  • There is some basic documentation under "documentation" on this site. Most controls have tooltips in the applications that explain their purpose.

Why would I need it?

To test the performance of Analysis Services in a "realistic" scenario where multiple clients concurrently issue queries.

Anything I should keep in mind?

  • This is Alpha software meaning bugs and issues are more or less guaranteed to pop up.
  • The network code uses synchronous TCP. This means it does not scale very well. I have tested it with ten clients but adding large numbers might slow things down. Moving to async TCP is on the list of future improvements.
  • StressTester is a client - server application where the server remotely controls the actions of the client program. This obviously is a concern seccurity-wise and the solution should not be deployed outside a firewall.

For more information:

http://peterkollerbi.wordpress.com

Last edited May 7, 2013 at 8:48 PM by Kollerp, version 20