April 24, 2014 at 4:20 pm
I need to find some sort SQL Server stress test tool to test performance on Inserts, Updates, Deletes possibly on simulating multiple users connecting. I had one at one time at an old company but can't remember what it was or if it's still relevant now. What are admins using nowadays? I found a 3rd party tool called SQLStress but it looks kinda dated.
Thanks
April 25, 2014 at 9:57 am
https://www.simple-talk.com/sql/database-administration/the-sql-server-sqliosim-utility/[/url]
http://www.brentozar.com/archive/2012/06/load-test-sqlserver/[/url]
Also, look for Dell's DVDStore tool. It can be a bit fiddly to set up but I found it good to simulate different workloads on different size databases.
Sure I can think of others, but hopefully these will get you started...
Edit: Yep...thought of another useful resource...
April 25, 2014 at 3:47 pm
Thanks I'll check it out
April 28, 2014 at 4:55 am
There's also the distributed replay tool that came out with SQL SErver 2012. That's worth checking out.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply