PrepAway - Latest Free Exam Questions & Answers

Which collector should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Query Activity collector

B.
Performance Counters collector

C.
T-SQL Query collector

D.
SQL Trace collector


Leave a Reply