How can we get performance improved after getting another new application server

[猿来是我]

Currently we have one application server, and we have a windows service running on it - retrieving data from database, filling out to a DataTable, and then do some kind of caculation and update each row in DataTable, finally save changes into Database.

And soon we would get another application server, what/how can we gain from this added physical resource(processor), HOW can we use multiple threads technology to improve the performance? Is there any best practices which i can follow in this case of multiple application servers?

Any comments is welcome.

[机器人]

数据量大的话，考虑使用多线程充分利用多核特性。 或者... 直接把计算移到存储过程里。