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.
Query Activity collector
C.
Performance Counters collector
D.
A custom Query collector that uses WMI