70-450 · Question #10
You administer a SQL Server 2008 infrastructure. The instance contains a database required for the day-to-day business of your company. Users experience slow response time when they execute reports…
The correct answer is A. Use the data collector. The data collector is a component installed on a SOL Server server, running all the time or on a user-defined schedule, and collecting different sets of data. The data collector then stores the collected data in a relational database known as the management data warehouse. The…
Question
You administer a SQL Server 2008 infrastructure. The instance contains a database required for the day-to-day business of your company. Users experience slow response time when they execute reports. You plan to design a performance monitoring strategy that captures and stores the following data:
- Executed Transact-SQL statements and query activity.
- Blocking and deadlock information.
- Counters for disk, CPU, and memory.
You need to implement the monitoring process by using the minimum amount of administrative effort. What should you do?
Options
- AUse the data collector
- BUse the client-side profiler trace.
- CUse the dynamic management views.
- DUse the System Monitor counter log trace.
How the community answered
(45 responses)- A76% (34)
- B16% (7)
- C2% (1)
- D7% (3)
Explanation
The data collector is a component installed on a SOL Server server, running all the time or on a user-defined schedule, and collecting different sets of data. The data collector then stores the collected data in a relational database known as the management data warehouse. The data collector is a core component of the data collection platform for SQL Server 2008 and the tools that are provided by SQL Server. The data collector provides one central point for data collection across your database servers and applications. This collection point can obtain data from a variety of sources and is not limited solely to performance data, unlike SOL Trace. w The data collector enables you to adjust the scope of data collection to suit your test and production environments. The data collector also uses a data warehouse, a relational database that enables you to manage the data you collect by setting different retention periods for your data. The data collector supports dynamic tuning for data collection and is extensible through its
Topics
Community Discussion
No community discussion yet for this question.