Microsoft
70-450 · Question #9
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 correct answer is C. Performance Counters collector. Background info:
Design and implement an optimized monitoring strategy
Question
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?
Options
- AT-SQL Query collector
- BQuery Activity collector
- CPerformance Counters collector
- DA custom Query collector that uses WMI
How the community answered
(27 responses)- A4% (1)
- B11% (3)
- C78% (21)
- D7% (2)
Explanation
Background info:
Topics
#data collector#deadlocks#distributed transactions#Performance Counters collector
Community Discussion
No community discussion yet for this question.