You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. 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 SQL Trace collector
B.
You should utilize Performance Counters collector
C.
You should utilize T-SQL Query collector
D.
You should utilize Query Activity collector