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?

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.
SQL Trace collector

B.
T-SQL Query collector

C.
Query Activity collector

D.
Performance Counters collector



Leave a Reply 0

Your email address will not be published. Required fields are marked *