Answer:
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