The Tool has very good documentation available. I have tried to run this tool based on stored procedure created in previous posts.
Step 1 - Tool Overview is provided in link
Step 2 - Download tool from link. Author is Adam Machanic.
Step 3 - Installed the tool
Step 4 - Set the Database connection and Select the Database from Drop Down menu
Step 5 - Provide the stored procedure and parameter name as in below snapshot. Stored Procedure reused from post.
Step 6 - Click on Parameter Substitution tab and provide query which returns test input. Query provided in below snapshot. Click on Get Columns.
Step 7 - Click on GO button and run the test. One Click to run the test. Executes test for each test row if results. CPU and IO statistics returned.
More Reads - SQLStress - A SQL Server Stress Test Tool
Happy Learning!!!
No comments:
Post a Comment