June 6, 2008 at 9:13 am
I wanted to Test my Database performance by increasing load to n number of users.
Is there any such script by which i can use the script of a single user for 100 or N numbers of Users.
Thanks in advance for all those replying me..
June 6, 2008 at 9:30 am
You'll have to do this from outside TSQL. I've done it two ways. First, write an app in .NET that opens threads and makes DB calls. It works, but it's kind of limited. The better approach is to buy a tool. Idera and Quest both have good tools that allow you to set up multiple client machines, marshal them through a central machine and then pound your database to dust with simultaneous users. Great way to do testing.
----------------------------------------------------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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply