SQL Server Performance Forum – Threads Archive

SMO vs SQL-DMO scripting

Hi,
Did anybody compare the performance of scripting operations with SQL-DMO vs SMO? What other reasons should be considered, to choose between two solutions?
Thanks.

Not yet myself, but I have heard, and it is known on MSDN forums that SMO is significantly slower than old fashioned DMO…

SMO is slower in some cases because it’s a much chattier api. However, in SMO you can control the chattiness. See:
http://blogs.msdn.com/mwories/archive/2005/04/22/smoperf1.aspx
http://blogs.msdn.com/mwories/archive/2005/04/22/smoperf2.aspx also, this thread has more replies here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75089
SqlSpec – a fast, cheap, and comprehensive data dictionary generator
for SQL Server 2000 and 2005 and Analysis Server 2005 – www.elsasoft.org

Thx for the links on how to improve SMO performance. Very helpful.

jezemine,
thank you for informative answers on all my posts. I have to study many things quickly, and these links were very helpful.
Thanks.

cool. that’s what forums are for [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] EDIT: one last comment. I don’t really fault SMO for being more chatty than DMO, especially since they provide you with a way to minimize the chattiness. I suppose you could fault DMO for being too eager in fetching all the properties of an object when you only ask for one (and you can’t control this). SMO uses "lazy fetch" but also lets you specify what you want and will fetch it eagerly if you know beforehand – this seems to be the best comprimise between lazy and eager fetch. <hr noshade size="1">SqlSpec – a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 and Analysis Server 2005 – www.elsasoft.org

]]>