I have been using this tool for various query testing over the last few months. Task relating to connectivity issues, query
tuning & even query load testing. It's good. And free. Download link below.
What is SQLQueryStress?
"SQLQueryStress is a free tool for SQL Server programmers. It is designed to assist with performance stress testing of T-SQL
queries and routines. The tool automatically collects metrics to help you determine whether your queries will perform under
load, and what kind of resource strain they put on your server."
Image #1:
SQLQueryStress Tool
|
|
|
|
|
|