July 15, 2010 at 1:06 pm
Are there any free tools available to similulate queries and user connections to a SQL database? We would like to know how many more user connections, queries, transactions, etc. that our SQL server can handle before we need to start thinking about a new server upgrade.
Thanks,
Dave
July 15, 2010 at 1:56 pm
Microsoft may have what you are looking for.
SQLIOSim - formerly SQLIOStress utility is an I/O stress utility for SQL Server.
The idea behind doing test-stressing on storage is that I/O subsystem is the slowest component of the system.
Check here ... http://support.microsoft.com/kb/231619
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.July 19, 2010 at 7:42 am
I've had great success using Quest's Benchmark Factory[/url]. It lets you define a load, scale it carefully... it's a great tool.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 19, 2010 at 8:18 am
Another simple tool is Adam Machanic's SQLQueryStress tool:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply