Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are SQL Server Management Objects?

April 26, 2017Management objects SQL Server

0

Posted

What are SQL Server Management Objects?

1 Answer

0

Posted

SQL Server management Objects (SMO) is the new Management Object Model for Yukon. SMO is a result of significant changes to the design and architecture of the existing SQL Server Distributed Management Objects (SQL-DMO). The earlier SQL-DMO was a set of objects encapsulating the MS SQL Server database and replication management. SQL DMO offered a developer a programmatic mechanism to monitor and control the SQL Server. The main advantage of this new set of objects is its performance and scalability. SMO also simplifies the interface to WMI, which would now allow easy integration to WMI for monitoring and server configuration.