I have been experimenting with multithreading the SMO database objects to increase performance in my application but i never seem to beable to push the cpu load of the system above 25% (4 processor server).
Has anyone successfully been multithreading these objects?
Niklas,
SMO can be used in multithreaded scenario, but improvements in performance highly depend on the design on your application. SMO applications are usually not CPU-bound, and the best strategy is usually to optmize the number of queries to the SQL Server SMO has to perform.
Here is a couple of great articles written by one of SMO architects Michiel Wories:
http://blogs.msdn.com/mwories/archive/2005/05/02/smoperf1.aspx
http://blogs.msdn.com/mwories/archive/2005/05/02/smoperf2.aspx
No comments:
Post a Comment