I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help you with your performance tuning process. Today, I am happy to share my first video going over these tools.
I am looking for a stress tool for SQL Server. I've seen a lot of suggestions on Google. But nothing of what I really need. I am really looking for a tool that could run a list of stored procedures in parallel to see how much contention on resources. The collect and reporting feature is not that important. OStress is a scalable and straightforward command line tool which can stress or replay database commands. It is designed to assist with performance stress testing of T-SQL queries.
Using SQLQueryStress to stress test Stored Procedures
Sql Load Testing Tool
SQLQueryStress by Adam Machanic (blog | twitter) is one of my favorite tools for doing a quick stress test against a user object like a stored procedure. This tool can actually be used to do stress testing on T-SQL queries but I usually use it for compiled objects like stored procedures. I love this tool because it allows you to save and load configurations to quickly redo tests. It also allows you to use a dataset for input parameters and allows you to add additional stress with configuring iterations and threads.
Note: It also comes in handy when you need to mock up some stress for demos.
Best Free Sql Server Tools
I also written a tip for www.mssqltips.com that goes over a step by step guide on how to use SQLQueryStress.