You administer a SQL Server 2008 infrastructure. A financial application uses several
instances across multiple servers. The majority of queries require distributed transactions
across all servers. The application administrator reports that the application experiences
excessive deadlocks. You need to design a data collector type that provides the appropriate
information for remote servers. What collector should you use?
A.
T-SQL Query collector
B.
Performance Counters collector
C.
A custom Query collector that uses WMI
D.
Query Activity collector