April 27, 2006 at 10:22 pm
I have designed a server which can inserts and process 12,000 records per minute. My requirement to insert and process 50,000 records per minute, I tried running server in clustered mode and created two instance of server on separate machine, both were simultaneous inserting and processing the records but still there is no significant improvement in performance. My question is how, what strategy I should follow to improve the performance, assuming server code is fully optimized.
April 28, 2006 at 5:02 am
I'm not sure I quite understand what you're doing but clustering is purely for availability , not for performance.
Largely the capacity for transactions is limited by the i/o capacity of the underlying disk subsystem, data and transaction log, and offset by the amount of memory - oh and then there's cpu's < grin >
your figure equates to around 833 i/o second which would be around 6 spindles in a raid 10 ( 12 disks in total ) check out the sql admin companion from ms press which explains these calcs or the performance handbook from ms press.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply