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?
A.
You should utilize Performance Counters collector
B.
You should utilize T-SQL Query collector
C.
You should utilize SQL Trace collector
D.
You should utilize Query Activity collector