What is the purpose of sys.dm_os_hosts?

 Posted by Niladri.Biswas on 7/26/2012 | Category: Sql Server Interview questions | Views: 2958 | Points: 40

This DMV returns all the hosts registered with SQL Server 2005.It also provides information like
a)Name: Name of the host registered
b)Type: Type of hosted component [SQL Native Interface/OLE DB/MSDART]
c)Active_tasks_count: Number active tasks host placed
d)Active_ios_count: I/O requests from host waiting

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response