70-450 · Question #6
You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a Windows Server 2008 64-bit server. The awe enabled option is enabled. The instance will experience a…
The correct answer is D. Performance Counters collector. This question is referencing SQL 2008's management data warehouse feature, which allows the collection of performance-related SQL statistics. The T-SQL Query collector allows you to write a custom query. The query is executed at intervals and the results are logged. The SQL…
Question
You administer a SQL Server 2008 instance. The instance is using a 32-bit version on a Windows Server 2008 64-bit server. The awe enabled option is enabled. The instance will experience a predictable increase in query activity. You plan to ascertain the appropriate time when the migration of the databases to a 64-bit SQL Server 2008 server on the same hardware is beneficial. You need to identify a data collector type that provides the appropriate information. Which collector should you use?
Options
- ASQL Trace collector
- BT-SQL Query collector
- CQuery Activity collector
- DPerformance Counters collector
How the community answered
(27 responses)- A11% (3)
- B4% (1)
- C4% (1)
- D81% (22)
Explanation
This question is referencing SQL 2008's management data warehouse feature, which allows the collection of performance-related SQL statistics. The T-SQL Query collector allows you to write a custom query. The query is executed at intervals and the results are logged. The SQL Trace collector leverages SQL Profiler to capture trace data. The performance counters collector tracks OS and SQL-related counters in the same way The query activity collector tracks DMV results. It is generally not used. As far as the question goes, it seems logical to pick the time when the server is experiencing the The performance counters collection makes the most sense, as it's possible to determine activity based on disk I/O, processor, memory, etc. performance.com/articles/per/System_Data_Collection_Reports_Install_p1.aspx
Topics
Community Discussion
No community discussion yet for this question.