70-450 · Question #79
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server…
The correct answer is B. You should utilize Performance Counters collector. Performance Counters collector is used as it contains information about the CPU, Memory and Disk usage of the SQL Server instance. As we need to know if it will o benefit to migrate to 64 bit version of SQL Server.
Question
You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server. You activate the awe enabled option. A predictable increase in query activity will be experienced by the instance. You are required to figure out the most proper and beneficial time to have the databases migrated to a 64-bit SQL Server 2008 server on the same hardware. A data collector type that proper information is provided should be identified. What kind of collector should you utilize?
Options
- AYou should utilize SQL Trace collector
- BYou should utilize Performance Counters collector
- CYou should utilize T-SQL Query collector
- DYou should utilize Query Activity collector
How the community answered
(24 responses)- A13% (3)
- B75% (18)
- C4% (1)
- D8% (2)
Explanation
Performance Counters collector is used as it contains information about the CPU, Memory and Disk usage of the SQL Server instance. As we need to know if it will o benefit to migrate to 64 bit version of SQL Server.
Topics
Community Discussion
No community discussion yet for this question.