June 23, 2011 at 12:07 pm
Hi,
I want to load test log shipping and Mirroring by inserting data continuously that generates huge log and want to see how that log or data is applying at standby server to measure the performance.
We do not have any tools in hand to perform this action and want some kind of script which can do this?
It should put load of 500 users accessing the database and doing the transactions.
Please advice?
June 23, 2011 at 12:27 pm
Even with 5000 users IIS isn't going to open up that many connections, and that's usually where you'll see a high user volume, is via a web-app.
My recommendation to you would be to create a while loop that will insert 2-5 records at a clip, will run for about 15 minutes (use actual time stamps to control it) and increase from there for volume if you need it. Run said script in 10-15 ssms windows and let 'er rip.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply