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