PrepAway - Latest Free Exam Questions & Answers

What kind of collector should you utilize?

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?

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply