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.
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.
I also written a tip for www.mssqltips.com that goes over a step by step guide on how to use SQLQueryStress.